Other than all previous comments, you can also do , SHOW CREATE TABLE tablename;
and then copy+paste it with a different tablename. Gurhan ----- Original Message ----- From: "Phil Schwarzmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 5:06 PM Subject: copying the structure of a table to a new table > I want to copy the structure of a table to a brand new table, but I > don't want to use phpmyadmin or some other program. I'm looking for the > command line code. > > Anyone have a link to where I can find it? Or, anyone wanna send me > the code? > > Thanks!! > > mysql > > --------------------------------------------------------------------- > 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
