Cannot create trigger – bad syntax
我想在事务表中每次插入后创建更新 total_money 的触发器。由于错误，我无法创建它：
#
1064 – Something is wrong in your syntax near ” in line 3
这是我的触发器创建代码：
如果添加分隔符，它将起作用，如下所示
分隔符 //
CREATE TRIGGER transactions_insert AFTER INSERT ON 事务
每一行开始
更新用户 SET users.total_money = users.total_money NEW.Price WHERE users.User_ID = NEW.User_id;
结尾;
//
来源：https://www.codenong.com/50356292/
微信公众号
手机浏览(小程序)
Warning: get_headers(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(): Failed to enable crypto in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
Warning: get_headers(https://static.shanhubei.com/qrcode/qrcode_viewid_9485.jpg): failed to open stream: operation failed in
/mydata/web/wwwshanhubei/web/wp-content/themes/shanhuke/single.php on line
57
