>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 [EMAIL PROTECTED] On Mon, 24 Jun 2002, Phil Schwarzmann wrote: > Date: Mon, 24 Jun 2002 17:06:19 -0400 > From: Phil Schwarzmann <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > 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
