一个库里有表A
建立个触发器,after insert on A ,
在过程里执行update A set... 尝试insert 测试数据到A表就...
报错
ERROR 1442 (HY000): Can't update table 'A' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
请教该怎么搞
建立个触发器,after insert on A ,
在过程里执行update A set... 尝试insert 测试数据到A表就...
报错
ERROR 1442 (HY000): Can't update table 'A' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
请教该怎么搞
用SET NEW.字段名= 123 试试
1:A表触发器执行一个INSERT B表的操作
2:B表的INSERT触发器,执行一个A表的操作。这样可以实现。
程序端发送insert a=0,b=0到A
需求是需要在每次对A insert时对那条插入的b值改为1
CREATE TRIGGER `mydb`.`A` before INSERT ON mydb.t1 FOR EACH ROW
BEGIN
set new.b=1;
END;
SET NEW.b= 1