HI,
I am new to this list and to mySQL.
I am trying to do a simple copy of a table with the
create-select and it has a problem with my code. I am
using version 3.22.23b. My code is:
create table newtable select * from oldtable;
Am I missing something? I know I can create the new
table and then insert into but this create seems so
slick, if it would work.
Thanks
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
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
