---我的触发器---
create or replace trigger trig_lj_sms(触发器名称) before(是插入之前还是之后,before是之前,after是之后) insert on lj_sms(表明)
for each row
begin
if :new.send_tel like '%5420%' then ---手机尾号是 5420 黑名单
:new.state:='black';
end if;
if :new.send_tel like '%5845%' then ---手机尾号是 5845 vip
:new.state:='vip';
end if;
create or replace trigger trig_lj_sms(触发器名称) before(是插入之前还是之后,before是之前,after是之后) insert on lj_sms(表明)
for each row
begin
if :new.send_tel like '%5420%' then ---手机尾号是 5420 黑名单
:new.state:='black';
end if;
if :new.send_tel like '%5845%' then ---手机尾号是 5845 vip
:new.state:='vip';
end if;
end;
-----删除触发器
drop trigger trig_lj_sms;