![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
herovictor_
这个作者很懒,什么都没留下…
展开
-
mysql 批量kill 掉语句
select concat('kill ',id,';') killStr,a.* from information_schema.`PROCESSLIST` a where a.info is not null order by a.time desc;原创 2020-07-13 14:34:28 · 655 阅读 · 0 评论 -
MYSQL分组获取前3 条数据
SELECT * FROM ( SELECT SALE_HISTORY_ID,CREATE_BY,PRICE,CREATE_TIME, IF(@tmp=CONCAT(SALE_HISTORY_ID,CREATE_BY),@rank:=@rank + 1,@rank:=1) as rowNum, @tmp:=CONCAT(SALE_HISTORY_ID,CREATE_BY) as tmp ...原创 2019-05-19 10:15:53 · 1179 阅读 · 0 评论