使用了一个insert触发器,之后就无法用load语句载入csv文件了,但是insert into执行正常
下面是定义的insert触发器
DELIMITER$$
CREATE TRIGGER trg_col_Cyear_insert_check BEFORE INSERT
ON ref_college FOR EACH ROW
BEGIN
IF new.Cyear<2010 OR new.Cyear>2057 THEN
INSERT INTO ref_college(category) VALUES(1);--用来抛出异常的语句
END IF;
END;$$
DELIMITER;
下面是报错
1442:
Can't update table 'ref_college' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
下面是定义的insert触发器
DELIMITER$$
CREATE TRIGGER trg_col_Cyear_insert_check BEFORE INSERT
ON ref_college FOR EACH ROW
BEGIN
IF new.Cyear<2010 OR new.Cyear>2057 THEN
INSERT INTO ref_college(category) VALUES(1);--用来抛出异常的语句
END IF;
END;$$
DELIMITER;
下面是报错
1442:
Can't update table 'ref_college' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.