mysql触发器

CREATE TABLE `tbl_import` (
`id` int NOT NULL AUTO_INCREMENT,
`record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '导入的表',
`recordName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '表的名称',
`createDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '任务开始时间',
`updateDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '任务更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `md5_value` (`md5_value`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

CREATE DEFINER=`root`@`%` TRIGGER `before_update_import` BEFORE UPDATE ON `tbl_import` FOR EACH ROW BEGIN
-- drop TRIGGER before_insert_import;
-- 校验record是否为字符串
IF NEW.record not REGEXP '[a-z]' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'record应为字符串';
END IF;

-- 校验 recordName 是否符合格式（简单示例）
IF NEW.recordName not REGEXP '^[一-龥]+$' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'recordname应为汉字';
END IF;

-- 检查 username 是否已经存在
IF not EXISTS (SELECT 1 FROM tbl_import_person WHERE record = NEW.record) THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'record not exists';
END IF;

END;

CREATE DEFINER=`root`@`%` TRIGGER `before_insert_import` BEFORE INSERT ON `tbl_import` FOR EACH ROW BEGIN
-- 校验record是否为字符串
IF NEW.record not REGEXP '[a-z]' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'record应为字符串';
END IF;
-- 校验 recordName 是否符合格式（简单示例）
IF NEW.recordName not REGEXP '^[一-龥]+$' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'recordname应为汉字';
END IF;
-- 检查 username 是否已经存在
IF not EXISTS (SELECT 1 FROM tbl_import_person WHERE record = NEW.record) THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'record not exists';
END IF;
END;