CREATE trigger tri_updateThreads AFTER UPDATE ON cdb_threads
FOR each ROW
BEGIN
if new.subject = old.subject THEN
UPDATE cdb_check SET isCheck =0 WHERE id = new.tid AND category =1;
END;
FOR each ROW
BEGIN
if new.subject = old.subject THEN
UPDATE cdb_check SET isCheck =0 WHERE id = new.tid AND category =1;
END;
解决方案 »
- 请教高手:怎末样将距阵存入MYSQL database?
- 急问 ACCESS数据如何转换成MYSQL
- mysql中的空字符串会给java返回什么
- 删除有相同one_id和other_id的记录,只剩下最新的一条
- 菜鸟求助:如何设计每日业绩录入与查询的数据表??
- 请问这段代码哪里错了 为什么我找不出来
- 把用select查询出来的结果怎样再数据插入到一张新表中?
- 用PHP+MYSQL做一个查询系统+网站建设最少需要花多少钱?谢谢
- mysql 辅库同步主库使用的问题
- 关于mysql字段的非null的不熟悉 虚心请教大婶们 NOT NULL ==?NOT NULL DEFAULT ''
- 关于数据库字段映射的问题
- 高分求助 mysql问题
FOR each ROW
BEGIN
if new.subject = old.subject THEN
UPDATE cdb_check SET isCheck =0 WHERE id = new.tid AND category =1;
end if; -- 少了个 END IF // ACMAIN
END;
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
Query OK, 0 rows affected (0.11 sec)mysql> delimiter //
mysql> CREATE trigger tri_updateThreads AFTER UPDATE ON cdb_threads
-> FOR each ROW
-> BEGIN
-> if new.subject = old.subject THEN
-> UPDATE cdb_check SET isCheck =0 WHERE id = new.tid AND category =1;
-> end if; -- 少了个 END IF // ACMAIN
-> END;
-> //
Query OK, 0 rows affected (0.09 sec)mysql> delimiter ;
mysql>测试没有任何问题。
SQL 查询: CREATE trigger tri_updateThreads AFTER UPDATE ON cdb_threads FOR each ROW BEGIN IF new.subject = old.subject THEN
UPDATE cdb_check SET isCheck =0 WHERE id = new.tid AND category =1;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
看一下5#楼