php触发器的问题
create trigger bookreturn before delete on borrowitem
for each row
begin
update book
set remain=remain+1
where book.bookid=old.bookid
end
you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near 'end' at line 5
无论我在程序里里面加不加分号都是这样。。。。
如果把
update book
set remain=remain+1
where book.bookid=old.bookid
去掉就没报错。。。
------解决方案--------------------
sql codedelimiter |create trigger bookreturn before delete on borrowitemfor each rowbeginupdate bookset remain=remain+1where book.bookid=old.bookid;end| delimiter ;