触发器如下:
delimiter //
CREATE TRIGGER t_check BEFORE UPDATE ON rocket.tab1
FOR EACH ROW
BEGIN
IF NEW.id < 0 THEN
SET NEW.name = '0';
ELSEIF NEW.id > 100 THEN
SET NEW.name = '100';
END IF;
END;//
delimiter ;错误信息提示:
ERROR 3 (HY000):Error writing file './rocket/t_check.trn~'(Errcode:28)
delimiter //
CREATE TRIGGER t_check BEFORE UPDATE ON rocket.tab1
FOR EACH ROW
BEGIN
IF NEW.id < 0 THEN
SET NEW.name = '0';
ELSEIF NEW.id > 100 THEN
SET NEW.name = '100';
END IF;
END;//
delimiter ;错误信息提示:
ERROR 3 (HY000):Error writing file './rocket/t_check.trn~'(Errcode:28)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货