MySQL8.0创建触发器
2021.12.5更新在测试中发现添加了referencing new row as newtuple 语句后会出现42000的报错,在查看mysql8.0官方文档后作出改进,代码如下所示:delimiter //create trigger xxxbefore insert on xxfor each statementbeginset @i := 1;set @a := (select a from xxx where x = NEW.x);end//delimiter ;去