duplicate a table
| From: | McShen | Date: | Mon, 02 Apr 2001 19:47:22 +0000 |
| Subject: | duplicate a table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8150@lists.php.net to get a copy of this message | ||
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,