mysql 分组加序号｜mysql 加序号
mysql 分组加序号｜mysql 加序号
不分组加序号
SELECT @serialNumber:=@serialNumber+1 AS `index`,book.*
FROM book,(SELECT @serialNumber:=0) serial_number
WHERE ******
ORDER BY CreateTime DESC;分组加序号
SELECT @serialNumber:=@serialNumber+1 AS `index`,book.*
FROM(
SELECT book.*
FROM book
WHERE *****
GROUP BY *****
) AS book
,(SELECT @serialNumber:=0) serial_number请先登录后再评论登录
