create trigger hqms_insert before insert
on hqms
for each row
begin
if new.id=22 then
signal sqlstate 'HY000' set message_text = '手动抛出异常' ;
end if;
insert into trigger_reget(sex) values(new.id);
end $$
mysql触发器 验证数据时,不符合不插入例子
最新推荐文章于 2022-04-20 22:27:58 发布