DROP TRIGGER tr_A710;
create trigger tr_A710 BEFORE INSERT on grade
for each row
BEGIN
DECLARE codeScore varchar(50); -- 定义变量
DECLARE codeId varchar(50); -- 定义变量
select id INTO codeId from student where id = new.id;
set codeScore = new.score; -- grade.score
set new.text= concat(codeId,replace(codeScore,'-','')); ---grade.text
END;
MySql触发器,新增表数据时更新自身表数据
于 2023-12-12 11:13:14 首次发布