Home > Backend Development > PHP Tutorial > PHP触发器的有关问题

PHP触发器的有关问题

WBOY
Release: 2016-06-13 10:29:34
Original
1013 people have browsed it

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 borrowitemfor each rowbeginupdate bookset remain=remain+1where    book.bookid=old.bookid;end| DELIMITER ;<div class="clear">
                 
              
              
        
            </div>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template