在SQL中复制MySQL表及数据

kider 发表于 2007-10-18 11:34:44

先复制表结构
mysql> create table city_copy like city;
Query OK, 0 rows affected (0.02 sec)

再复制表数据
mysql> insert into city_copy select * from city;
Query OK, 4079 rows affected (0.09 sec)
Records: 4079Duplicates: 0Warnings: 0

wugufly 发表于 2008-1-27 15:45:52