mysql触发器一直报错，新手不知道错哪

答案:2 悬赏:50 手机版

解决时间 2021-03-11 14:45

提问者网友：城市野鹿
2021-03-10 21:22

DELIMITER $$
CREATE TRIGGER t_insert BEFORE INSERT ON bookmanagement.reader
FOR EACH ROW
BEGIN
IF exists(SELECt * FROM reader WHERe readerId=new.readerId)
UPDATE reader SET sum = sum+1 WHERe readerId=new.readerId;
ELSE
INSERT INTO reader(readerId,Name,sex) VALUES(new.readerId,new.Name,new.sex);
END $$
DELIMITER ;

最佳答案

五星知识达人网友：迷人又混蛋
2021-03-10 22:23

delimiter //create trigger person_delbefore delete on personfor each rowbegin delete from gay where no=old.no;end;//delimiter ; 如果出错的话, 报一下错误信息是什么. 看看提示出错在哪一行.

全部回答

1楼网友：神鬼未生
2021-03-10 22:51

可以试试下面的 delimiter $$ create trigger up_point after update on grading for each row begin declare avgmarks decimal(4,2); select avg(cast(marks as decimal(4,2))) into avgmarks from grading where grading.id_2=new.id_2; update base_info set avg_marks=avgmarks where base_info.id=new.id_2; end$$ delimiter ;

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息