指定某个列进行排序,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……