日期:2014-05-16 浏览次数:20790 次
create trigger trg1 After insert on idi For each row Begin update uk set kucun = kucun-new.num where iid = new.id; End
错误 SQL 查询: CREATE trigger trg1 AFTER INSERT ON idi FOR each ROW BEGIN UPDATE uk SET kucun = kucun - new.num WHERE iid = new.id; 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 '' at line 5