mysql查询自增id

 

SELECT
  (@row_number := @row_number + 1) AS id
  from lable tt,
  (SELECT @row_number := 0) AS t

lable ： 数据表

(SELECT @row_number := 0) AS t ： 将 @row_number 重置为 0