在SQL中复制MySQL表及数据

kider

先复制表结构
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: 4079  Duplicates: 0  Warnings: 0

wugufly

好 学习啦

mysqlkumao