Re: copying the structure of a table to a new table

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" <pschwar@xxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
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 <mysql-thread112885@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-ergenekon=starpower.net@xxxxxxxxxxxxxxx>
> 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 <mysql-thread112892@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php