PHP触发器的有关问题

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 code

DELIMITER |
create trigger bookreturn before delete on borrowitem
for each row
begin
update book
set remain=remain+1
where    book.bookid=old.bookid;
end

|
 
DELIMITER ; 

                 
              
              
        
            
      
      
remain bookid book update wherePHP课程HTML视频教程CSS视频JS视频教程Vue视频教程

      
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。