指定某个列进行排序,ASC 为升序,DESC 为降序。
SELECT * FROM Consult ORDER BY add_time DESC LIMIT %d,%d 按add_time 减序排列
SELECT * FROM Consult ORDER BY add_time ASC LIMIT %d,%d 按add_time 升序排列
指定某个列进行排序,ASC 为升序,DESC 为降序。
SELECT * FROM Consult ORDER BY add_time DESC LIMIT %d,%d 按add_time 减序排列
SELECT * FROM Consult ORDER BY add_time ASC LIMIT %d,%d 按add_time 升序排列