我有一个触发器,里面的sql语句执行时间为0.2秒左右,触发事件是字段的更新,
这样单行执行是没什么问题,问题是执行多个就出现很慢的情况,我用的where 语句是 between 1 and 50
和in(1-50)语句,有没有方法让他在between和in语句执行完之后再触发
这样单行执行是没什么问题,问题是执行多个就出现很慢的情况,我用的where 语句是 between 1 and 50
和in(1-50)语句,有没有方法让他在between和in语句执行完之后再触发
解决方案 »
- sql server 2005 按位操作怎么写。急!!!!!在线
- 使用游标出现 No data - zero rows fetched, selected, or processed
- Weblogic 7.0 替换mysql驱动包
- mysql的用户表中“任意”“build ”代表什么意思
- 有没有这样的SQL语句可以用啊?
- postgresql在WINDOWS下的管理工具哪里有下载
- RPM安装MySQL4.1是的错误信息?请帮忙解决,谢谢!
- MYSql For Windows版30天试用期后是否就不能用了?
- 谁在一台机器上装过两个mysql吗,急
- mysql8.0 字符集用utf8还是用utf8mb4
- mysql 索引使用问题解惑?!
- MySQL语句的转化
select 1,id,sum(paint_num) as paint_num,sum(review_num) as review_num from
(select 1 , picture_reviewer as id, 0 as paint_num,count(picture_id) as review_num from u_picture where picture_status IN ('to review','reviewing') GROUP BY picture_reviewer
UNION
select 1, picture_painter as id, count(picture_id) as paint_num,0 as review_num from u_picture where picture_status IN ('to paint','painting','to repaint','repainting') GROUP BY picture_painter) as test GROUP BY id;这个是触发器的代码
update u_picture set picture_status='painting' where picture_id BETWEEN 5000 and 5050这个是update的代码 运行时间要6秒