[MySQL]MySQL的signal sqlstate

124 阅读 0 评论 82 点赞

我是靠谱客的博主温柔身影，这篇文章主要介绍[MySQL]MySQL的signal sqlstate，现在分享给大家，希望可以做个参考。

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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;