在 MySQL 中复制表的方式有三种:
create table tableName like some_table;
例如将 students 表的结构复制给 新建的users表:
create table users like students;
create table tableNmae select * from some_table;
例如将 students 表的数据复制给新建的users表:
create table users select * from students;
create table users like students;
insert into users select * from students;