MySql中，復制舊表結構到新表，mysql復制表結構

MySql中，復制舊表結構到新表，mysql復制表結構

# 創建學生表

create table student(age int,name varchar(32))engine myisam charset utf8;
insert into student values(18,'小白');

# 創建教師表，結構與學生表結構一模一樣
create table teacher like student;

# 把學生表的數據寫進教師表中
insert into teacher select * from student;

# 創建家長表，結構與數據與學生表一模一樣
create table parent select * from student;

#創建學校表，結構與學生表一樣
create table school select * from student where 1 = 2;#即條件不成立