sql语句报错,请教~~~

miniala 2012-10-30 11:22:44
请教下面这个哪里出错了呢~~~

#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 7

CREATE TRIGGER trg_task
AFTER UPDATE ON projects
FOR EACH ROW
BEGIN
CASE NEW.project_status
WHEN 'COMPLETED' THEN
UPDATE tasks SET task_percent=100 WHERE project_id = NEW.project_id;
WHEN 'CANCELLED' THEN
UPDATE tasks SET task_percent=-1 WHERE project_id = NEW.project_id;
END CASE;
END

...全文
83 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
WWWWA 2012-10-31
  • 打赏
  • 举报
回复
DELIMITER $$
CREATE TRIGGER trg_task
AFTER UPDATE ON projects
FOR EACH ROW
BEGIN
CASE NEW.project_status
WHEN 'COMPLETED' THEN
UPDATE tasks SET task_percent=100 WHERE project_id = NEW.project_id;
WHEN 'CANCELLED' THEN
UPDATE tasks SET task_percent=-1 WHERE project_id = NEW.project_id;
END CASE;
END$$
DELIMITER ;
ACMAIN_CHM 2012-10-31
  • 打赏
  • 举报
回复
delimiter //
CREATE TRIGGER trg_task
AFTER UPDATE ON projects
FOR EACH ROW
BEGIN
CASE NEW.project_status
WHEN 'COMPLETED' THEN
UPDATE tasks SET task_percent=100 WHERE project_id = NEW.project_id;
WHEN 'CANCELLED' THEN
UPDATE tasks SET task_percent=-1 WHERE project_id = NEW.project_id;
END CASE;
END

//

56,677

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧