MySQL笔记

1. MySQL查询行号

SELECT @rownum:=@rownum+1 rownum, CollectSn From
(SELECT @rownum:=0,bbgmain.* FROM qbdb.bbgmain WHERE collectsn!='' ORDER BY collectsn limit 10) t
posted @ 2017-06-29 15:11  wlzjdm  阅读(166)  评论(0)  编辑  收藏  举报