PHP triggers-php Tutorial

PHP trigger problems: createtriggerbookreturnbeforedeleteonborrowitemforeachrowbeginupdatebooksetremainremain + 1wherebook. bookidold. bookidendYouhaveanerrorinyourSQLsynt PHP trigger problems
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
No matter whether I add a plus sign in the program, this is the case ....
If
Update book
Set remain = remain + 1
Wherebook. bookid = old. bookid
If this parameter is removed, no error is reported...

------ Solution --------------------

SQL code

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