herovictor_的博客

select concat('kill ',id,';') killStr,a.* from information_schema.`PROCESSLIST` a where a.info is not null order by a.time desc;

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