-- 创建学生表
DROP TABLE IF EXISTS student;
CREATE TABLE student (
studentID INT,
studentName VARCHAR(50),
classID INT
);
-- 创建班级表
DROP TABLE IF EXISTS class;
CREATE TABLE class (
classID INT,
studentCount INT
);
-- 向班级表中插入数据
INSERT INTO class (classID,studentCount) VALUES (1,0);
INSERT INTO class (classID,studentCount) VALUES (2,0);
INSERT INTO class (classID,studentCount) VALUES (3,0);
(2)创建触发器
drop trigger if exists triggerName;
delimiter //
create trigger triggerName
after insert on student for each row
begin
update class set studentCount = studentCount + 1 where classID=NEW.classID;
end //
delimiter ;
-- 向学生表中插入数据
insert into student(studentID,studentName,classID)
values(00001,'lilil',1);
-- 查询
select * from student;
select * from class;
NEW关键字。在MySQL中定义了NEW 和 OLD 表示了触发器在所在表中,触发了触发器的哪一行数据