触发器 :插入语句，删除语句，修改语句

#建库
CREATE DATABASE IF NOT EXISTS ku DEFAULT CHARSET utf8;
USE ku;

#建表
CREATE TABLE IF NOT EXISTS student
(
    username VARCHAR(50),
    PASSWORD VARCHAR(50),
    stuid INT PRIMARY KEY AUTO_INCREMENT,
    dirthday DATE
);

#插入数据
INSERT INTO student(username,PASSWORD,dirthday)VALUES
("王佣兵","111","2002-08-23");

#查询
SELECT * FROM student;

#建表
CREATE TABLE IF NOT EXISTS cj
(
    num INT PRIMARY KEY AUTO_INCREMENT,
    stu_id INT,
    stu_name VARCHAR(50),
    math FLOAT,
    chinese FLOAT,
    english FLOAT
);

#查询
SELECT * FROM cj;

#触发器 :插入语句
DELIMITER $
CREATE TRIGGER abcd
AFTER INSERT ON student FOR EACH ROW
BEGIN
INSERT INTO cj(stu_id,stu_name)VALUES(new.stuid,new.username);
END $
DELIMITER ;

#执行触发器
INSERT INTO student(username,PASSWORD,dirthday)VALUES
("张三","222","2003-02-22");

#触发器：删除语句
DELIMITER $
CREATE TRIGGER b
AFTER INSERT ON student FOR EACH ROW
BEGIN
DELETE FROM cj WHERE cj.stu_id=old.stuid;
END $
DELIMITER ;

#触发器：修改语句
DELIMITER $
CREATE TRIGGER c
AFTER INSERT ON student FOR EACH ROW
BEGIN
UPDATE cj SET cj.stu_name=old.username WHERE cj.stu_id=old.stuid;
END $
DELIMITER ;