觸發器陳述句如下
CREATE TRIGGER `account_add` AFTER INSERT ON `account` FOR EACH ROW
BEGIN
UPDATE company_info_statistics cis
SET cis.ACCOUNT_NUM = cis.ACCOUNT_NUM + 1
WHERE
cis.COMPANY_INFO_ID = new.COMPANY_ID;
END;
在mysql8 中執行，提示語法錯誤，找了好長時間，也沒有找到哪兒有問題， 下面是錯誤資訊
CREATE TRIGGER `account_add` AFTER INSERT ON `account` FOR EACH ROW
BEGIN
UPDATE company_info_statistics cis
SET cis.ACCOUNT_NUM = cis.ACCOUNT_NUM + 1
WHERE
cis.COMPANY_INFO_ID = new.COMPANY_ID
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 '' at line 6
時間: 0.017s
uj5u.com熱心網友回復：
最后沒分號碼轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/40216.html
標籤：MySQL