mysql快速复制表

方法一:

• 查看创表语句

  show create table tablename;

   

• 使用创建表语句修改新表名创建表;
• 插入数据

  insert into newtablename select *from tablename;

   

---

方法二:

• CREATE TABLE targetTable LIKE sourceTable;

   

• INSERT INTO targetTable SELECT * FROM sourceTable;

   

---

方法三:

• 只复制表结构

  create table newtablename select * from tablename where 1=2;

   

• 复制表结构和数据

  create table newtablename select * from tablename;