当前位置：网站首页>MySQL query with serial number

MySQL query with serial number

select (@i :=@i+1) as num,id,qzlb 
from t_supplier_ca , (select @i:=0) as init  where id <>5

(select @i:=0) as init Represents the initial value of the sequence by 0

(@i :=@i+1) Representative increment , Every time +1

Query results

版权声明
本文为[The evening wind in summer night.]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221857450048.html