56,677
社区成员
发帖
与我相关
我的任务
分享
create trigger check_after_update_msclientmembercard
after update on ms_client_membercard
for each row
if new.remain_money < 0 then
update ms_client_membercard set remain_money = 0 where client_id = new.client_id;
create trigger update_cardstatus_after_insert_clientinfo
after insert on clienttradejour
for each row
if new.trade_item = '升级' then
insert into ms_client_promotion (client_id,client_name,promotion_time,after_card,receive_money,operator)
select client_id,name,trade_time,card_type,receive_money,operator from clienttradejour where client_id = new.client_id
麻烦帮我看看这个哪里有错啊,报错信息很少,看不出来reate trigger update_cardstatus_after_insert_clientinfo
after insert on clienttradejour
for each row
begin
if new.trade_item = '升级' then
insert into ms_client_promotion (client_id,client_name,promotion_time,after_card,receive_money,operator)
select client_id,name,trade_time,card_type,receive_money,operator from clienttradejour where client_id = new.client_id
end if;
end;
create trigger update_cardstatus_after_insert_clientinfo
after insert on clienttradejour
for each row
if new.trade_item = '升级' then
insert into ms_client_promotion (client_id,client_name,promotion_time,after_card,receive_money,operator)
select client_id,name,trade_time,card_type,receive_money,operator from clienttradejour where client_id = new.client_id
delimiter $
create trigger check_after_update_msclientmembercard
before update on ms_client_membercard
for each row
begin
if new.remain_money < 0 then
set new.remain_money=0;
end if;
end $
delimiter $
create trigger check_after_update_msclientmembercard
after update on ms_client_membercard
for each row
begin
if new.remain_money < 0 then
set new.remain_money=0;
end if;
end $