设置mysql数据库某个字段为自增序列

设置某个字段为自增序列

LPAD用法

select LPAD('1', 8, 0) -- 00000001

语法设置

SET @rownum = 0;
UPDATE user
SET code = 
concat ( 'USER98', LPAD( ( SELECT @rownum := @rownum + 1 AS nid ), 8, 0 ) ) 
WHERE
	id < 90000000;

执行结果

USER9800000001
USER9800000002
USER9800000003
...