See mysqldump utility, it does exactly what you ask. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Sterling J. Anderson wrote: > Date: Tue, 19 Feb 2002 11:14:11 -0600 > From: Sterling J. Anderson <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Generating SQL code? > > I am going to be copying some tables from one DB to another and was > wondering if it is possible to have MySQL output the SQL Create Table > syntax? > I know there are products that will do that (ie. MyPHPAdmin) but can > MySQL do it? I'd rather not put anything extra on my server. Thanks. > > ________________________________________________________ > Sterling J. Anderson > email: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php