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

>From pg 149 of the New Riders Press book
"MySQL" by Paul DuBois (ISBN 0-7357-0921-1):

CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0

--
 Mark P. Hennessy                                             mark@xxxxxxxxxx

On Mon, 24 Jun 2002, Phil Schwarzmann wrote:

> Date: Mon, 24 Jun 2002 17:06:19 -0400
> From: Phil Schwarzmann <pschwar@xxxxxxxx>
> To: mysql@xxxxxxxxxxxxxxx
> 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-mark=cloud9.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-thread112890@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php