-- 写一下MySQL触发器
DELIMITER $$
CREATE TRIGGER tr_user_insert AFTER INSERT ON s
FOR EACH ROW
BEGIN
INSERT INTO c(cno,cname,CTEACHER)
VALUES(6,6,'王二小');
END;
$$
DELIMITER ;
-- 测试一下,c 表会自动添加一条记录
INSERT INTO s(sno,sname)
VALUES(8,'王二小的老师');
-- 写一下MySQL触发器
DELIMITER $$
CREATE TRIGGER tr_user_insert AFTER INSERT ON s
FOR EACH ROW
BEGIN
INSERT INTO c(cno,cname,CTEACHER)
VALUES(6,6,'王二小');
END;
$$
DELIMITER ;
-- 测试一下,c 表会自动添加一条记录
INSERT INTO s(sno,sname)
VALUES(8,'王二小的老师');