MYSQL 特殊查询用法

查询一堆数据，把指定 id 的那条数据放到第一条,其余的按创建时间倒叙

select id , title ,create_time from tb_purchase order by 
case when id = 9 then id end desc , case when id <> 9 then create_time end desc

 

 获得从一个日期开始以后的连续日期

select 
DATE_ADD(now(),INTERVAL @r DAY) as date, @r :=@r + 1 as DAY 
from tb_coin_pay_trade, 
(select @r := 0 ) a