MySQL 下面没有RowNum,排序后序号却无法得到,比较麻烦!
SELECT @rownum:=@rownum+1 rownum,calendar_date From (SELECT @rownum:=0,calendar_date FROM mo_workdate WHERE calendar_date!='' ORDER BY calendar_date) t;
SELECT @rownum:=@rownum+1 rownum,calendar_date From (SELECT @rownum:=0,calendar_date FROM mo_workdate WHERE calendar_date!='' ORDER BY calendar_date) t;