请教下面这个哪里出错了呢~~~#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
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
解决方案 »
- sql同一列相同的值
- 将一个字段里的值复制添加到另一个字段中 怎么写呢
- 后台调用存储过程的时候,怎么传进去一个临时变量呀,急~~~~~坐等
- 存储过程关闭游标后面的sql语句是滞还会继续执行?
- 安装完成后,无法启动服务。MYSQL For Windows V5.1.32 免费版.msi
- 我想在表里查找相同的两行,总是查不出结果。
- Mysql是否存在函数,可将result的结果(只有一列,N行)存为一个数组,请教了.
- MySQL Error: You have an error in your SQL syntax; check the manual that corresp
- 为什么删除不了这一行!!
- show profile 的字段含义
- toad for mysql有没有中文教程呀,
- mysql 对于 select 一列多值 有什么好的替代方法?
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 ;
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
//