PHP觸發器的有關問題

PHP觸發器的問題
create trigger bookreturn before delete on borrowitem
for each row
begin
update book
set remain=remain+1
wherebook.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
wherebook.bookid=old.bookid
去掉就沒報錯。。。

------解決方案--------------------

SQL code

DELIMITER |create trigger bookreturn before delete on borrowitemfor each rowbeginupdate bookset remain=remain+1where    book.bookid=old.bookid;end| DELIMITER ;
