delimiter //
CREATE TRIGGER ALT_TRI_Southwest AFTER update ON Southwest
for each row
BEGIN
declare team VARCHAR(40);
declare cur_name cursor for select name from southwest where new.win>old.win || new.lose>old.lose;
open cur_name;
fetch cur_name into team;
if new.win>old.win then
update Western set win=win+1 where Western.name=@team;
else
update Western set lose=lose+1;
end if;
close cur_name;
END//
delimiter ;谢谢!!
CREATE TRIGGER ALT_TRI_Southwest AFTER update ON Southwest
for each row
BEGIN
declare team VARCHAR(40);
declare cur_name cursor for select name from southwest where new.win>old.win || new.lose>old.lose;
open cur_name;
fetch cur_name into team;
if new.win>old.win then
update Western set win=win+1 where Western.name=@team;
else
update Western set lose=lose+1;
end if;
close cur_name;
END//
delimiter ;谢谢!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货