[PHP-DB] duplicate a table

[McShen]

how do i duplicate a table?
i tried
create table refer2 select * from refer;
create table refer2 as select * from refer;

they didn't work.
my mysql version is  mysql 3.22.28,



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]