56,679
社区成员
发帖
与我相关
我的任务
分享有谁碰到过这样的问题吗?
触发器内容如下:
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)
...全文
请发表友善的回复…
发表回复
懒得去死 2007-10-02
- 打赏
- 举报
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 ;
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 ;
