mysql signal_[MySQL]MySQL的signal sqlstate

[code]drop trigger trig_test;

create trigger trig_test before insert on udf_update_delivery

for each row

begin

declare msg varchar(20);

set msg='提交数据错误,请检查';

if new.delivery_no like '99-300101%' then

signal sqlstate '45000' set message_text=msg;

end if;

end;

insert into udf_update_delivery(delivery_no,is_update,update_date)

values('99-300101111',1,'2020-03-10')

drop trigger trig_srm_delivery_head;

create trigger trig_srm_delivery_head before insert on srm_delivery_head

for each row

begin

declare msg varchar(20);

set msg='提交数据错误,请检查';

if new.delivery_no like '99-300101%' then

signal sqlstate '45000' set message_text=msg;

end if;

end;