一.右键表格后点击设计表,在触发器那栏可以使用添加触发器等功能
二.
1.删除
BEGIN
DELETE FROM score WHERE student_id = old.student_id;
END
2.更新
BEGIN
UPDATE score SET student_id = new.student_id WHERE student_id = old.student_id;
END
3. 插入
BEGIN
INSERT INTO score(student_id)
VALUES(new.student_id,new.student_name);
end