At 04:06 PM 6/24/2002, you wrote:
>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
Phil,
This is only half a solution, but it is better than nothing, right?<g>
create table newtable select * from oldtable limit 0;
This will create a newtable with the same columns as oldtable and newtable
will be empty.
Alas, the index definitions are not copied over so that will have to be
done manually or someone else can offer a suggestion. I was thinking of
writing a PHP function to do it. It's not that difficult (I think?!).
Mike
---------------------------------------------------------------------
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
