帮忙写一个 mysql update 触发器
发布网友
发布时间:2022-04-13 03:31
我来回答
共2个回答
热心网友
时间:2022-04-13 05:01
1 DROP TRIGGER IF EXISTS t_update_on_st_shop_info;
2 CREATE TRIGGER t_update_on_st_shop_info
3 UPDATE ON st_shop_info
4 FOR EACH ROW
5 BEGIN
6 UPDATE st_shop_info SET open_flg=1 where shop_indate>0;
7 INSERT INTO st_shop(shop_id) VALUES (new.st_shop_info_shop_id);
8 END;
不知道这个行不行,你试试,最好你的表名少用下划线
热心网友
时间:2022-04-13 06:19
1 DROP TRIGGER IF EXISTS t_update_on_st_shop_info;
2 CREATE TRIGGER t_update_on_st_shop_info
3 UPDATE ON st_shop_info
4 FOR EACH ROW
5 BEGIN
6 UPDATE st_shop_info SET open_flg=1 where shop_indate>0;
7 INSERT INTO st_shop(shop_id) VALUES (new.st_shop_info_shop_id);
8 END;
不知道这个行不行,你试试,最好你的表名少用下划线追问虽然不是我要的答案
你上面的UPDATE st_shop_info SET open_flg=1 where shop_indate>0;
不能这样写 要
if new.shop_indate>0 then
set new.open_flg=1;
才是对的
追答哦,知道了