– mysql 获取自增长的序列号
SELECT a.*,(@rowNum:=@rowNum+1) AS rowNum FROM c_bd_enterprise a,(SELECT (@rowNum :=0) ) b
– mysql 获取自增长的序列号 前面补0操作
SELECT LPAD((@rowNum:=@rowNum+1),2,0) AS rowNum FROM s_pb_sysdicinfo a,(SELECT (@rowNum :=0) ) b WHERE @rowNum <30