SELECT
@xuhao := @xuhao + 1 AS num,
factor_id
FROM
bx_well_factor,
( SELECT @xuhao := 0 ) b #声明变量
WHERE
del_flag = '0'
ORDER BY
factor_code ASC
SELECT
@xuhao := @xuhao + 1 AS num,
factor_id
FROM
bx_well_factor,
( SELECT @xuhao := 0 ) b #声明变量
WHERE
del_flag = '0'
ORDER BY
factor_code ASC