mysql order by默认是升序还是降序

mysql order by默认是升序还是降序SQL语言的默认排序方式是升序，ORDER BY 子句若未显式指定升序(ASC)或降序(DESC)，那么就认按默认升序排序。例如下列语句为默认按升序排序select * from t1 order by col1它与下列语句等效select * from t1 order by col1 asc

"order by ITEM_AUTO_ID desc LIMIT "+nowRowNumber+","+DATANUMBERS

desc 降序；asc升序（默认升序）

limit 参数一，参数二；参数一为起始偏移量，参数二为最大行数

---