mysql 实现自增序列

select  replace( UUID(),'-','') as gw_id,@row_number := @row_number + 1 AS gwbm,t.职务名称 as gwmc

FROM
(
select distinct 职务名称 from tb_yhxx
)t,    (SELECT @row_number := 0) AS t1;