--- 每一个班主任会对应多个学生 , 而每个学生只能对应一个班主任
----主表
CREATE TABLEClassCharger(
idTINYINT PRIMARY KEYauto_increment,
nameVARCHAR (20),
ageINT,
is_marriged boolean--show create table ClassCharger: tinyint(1)
);INSERT INTO ClassCharger (name,age,is_marriged) VALUES ("冰冰",12,0),
("丹丹",14,0),
("歪歪",22,0),
("姗姗",20,0),
("小雨",21,0);----子表
CREATE TABLEStudent(
idINT PRIMARY KEYauto_increment,
nameVARCHAR (20),
charger_idTINYINT, --切记:作为外键一定要和关联主键的数据类型保持一致
FOREIGN KEY (charger_id) REFERENCES ClassCharger(id), 关联外建 charger_id字段当前表 到 classcharger表的id字段
--ADD CONSTRAINT charger_fk_stu FOREIGN KEY (charger_id) REFERENCES ClassCharger(id) ##给外建加名字 ADD CONSTARAINT charger_fk_stu 这段是自己加上外键名字
) ENGINE=INNODB;INSERT INTO Student(name,charger_id) VALUES ("alvin1",2),