CREATE TRIGGER `tri_delnotpermit` BEFORE DELETE ON `UserT`
FOR EACH ROW begin
declare msg varchar(255);
set msg="不允许删除用户信息";
SIGNAL SQLSTATE 'HY000' SET MESSAGE_TEXT = msg;
end;
CREATE TRIGGER `tri_delnotpermit` BEFORE DELETE ON `UserT`
FOR EACH ROW begin
declare msg varchar(255);
set msg="不允许删除用户信息";
SIGNAL SQLSTATE 'HY000' SET MESSAGE_TEXT = msg;
end;