create trigger cargo_update
on cargo for update
as
begin
update cargo set bid=0 where amount=0
end
触发器创建失败,怎么样才能运行
第1个回答 2015-05-08
在mysql 中update 触发器中语句不能再update 这张表 不然会报错 嵌套update
DELIMITER $$
CREATE TRIGGER cargo_update before delete ON cargo
FOR EACH ROW
BEGIN
//语句
END$$追问
DELIMITER $$
CREATE TRIGGER cargo_update before delete ON cargo
FOR EACH ROW
BEGIN
//语句
END$$追问
那怎么写?还是没看懂