1. 复制一张表, (结构+表中的内容)
create table teacher_bak as select * from teacher;
2.插入来自其他表的记录
insert into A表 select a,b,c from B表;
3. 只复制一张表的结构
create table teacher_bak as select * from teacher where 1=2;
1. 复制一张表, (结构+表中的内容)
create table teacher_bak as select * from teacher;
2.插入来自其他表的记录
insert into A表 select a,b,c from B表;
3. 只复制一张表的结构
create table teacher_bak as select * from teacher where 1=2;