针对PHPWind的 CREATE TRIGGER AddBbsCredit AFTER INSERT ON pw_threads For EACH ROW BEGIN UPDATE pw_memberdata SET postnum = postnum + 1, rvrc = rvrc + 1, money = money + 10 WHERE uid = NEW.authorid END
为什么换成5.0还是出错 --------------------- 错误 SQL 查询: CREATE TRIGGER AddBbsCredit AFTER INSERT ON pw_threads FOR EACH ROW BEGIN UPDATE pw_memberdata SET postnum = postnum +1, rvrc = rvrc +1, money = money +10 WHERE uid = NEW.authorid END MySQL 返回: #1064 - 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 'UPDATE pw_memberdata SET postnum = postnum + 1, rvrc = rvrc + [ 返回 ]
CREATE TRIGGER AddBbsCredit
AFTER INSERT ON pw_threads
For EACH ROW
BEGIN
UPDATE pw_memberdata SET
postnum = postnum + 1,
rvrc = rvrc + 1,
money = money + 10
WHERE uid = NEW.authorid
END
---------------------
错误
SQL 查询: CREATE TRIGGER AddBbsCredit AFTER INSERT ON pw_threads
FOR EACH
ROW
BEGIN
UPDATE pw_memberdata SET postnum = postnum +1,
rvrc = rvrc +1,
money = money +10 WHERE uid = NEW.authorid END MySQL 返回: #1064 - 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 'UPDATE pw_memberdata SET
postnum = postnum + 1,
rvrc = rvrc + [ 返回 ]