# 創建學生表 create table student(age int,name varchar(32))engine myisam charset utf8;insert into student values(18,'小白'); # 創建教師表，結構與學生表結構一模一樣create table ...
# 創建學生表
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;#即條件不成立
