6、插入数据

(1) 省略字段名：

插入：insert into Student values('20200001','张三','2002-07-01','男');

查询： Select * from Student;

(2）有字段名：

insert into Student(Sid,Sname,Sage,Ssex)values('20200002','李四','2002-08-15','男');

（3）一次加多条记录

insert into Teacher values('0001','钟硕果'),('0002','李丽红');

（4）

insert into Course values('040901','数据库技术','0001');

（5）失败示范 insert into Course values('040902','单片机','0003');

（6）正确输入 insert into Course values('040902','单片机','0002');

（7）insert into SC values('20200001','040901',90);

（8）失败示范 insert into SC values('20200001','040901',99);

查询结果：Select * from Student;Select * from Teacher;Select * from Course;Select * from SC;

mysql> Select * from Student,Teacher,Course,SC;