一:首先创建表
二:创建好后点击设计表中的触发器
三:1)插入
BEGIN
if new.student_age<16 THEN SET new.student_age = 16;
END if;
END
2)更新
BEGIN
UPDATE score SET student_id = new.student_id WHERE student_id = old.student_id;
END
3)删除
BEGIN
DELETE FROM score WHERE student_id = old.student_id;
END