select @rownum:=@rownum+1 as rownum, l.* from spc_law l, ( SELECT @rownum := 0 ) t order by type asc;
mysql 生成序号 且自增
最新推荐文章于 2024-05-31 14:16:03 发布
select @rownum:=@rownum+1 as rownum, l.* from spc_law l, ( SELECT @rownum := 0 ) t order by type asc;