mysql怎么把随机生成的id改成自动增长的id

发布网友 发布时间：2022-05-08 02:58

我来回答

共4个回答

热心网友 时间：2022-05-08 04:27

SELECT concat(concat(concat(concat(concat(concat(concat(concat(concat(concat("",substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)),substring('QWERTYUIOPASDFGHJKLZXCVBNMabcdefghijklmnopqrstuvwxyz0123456789',floor(1+rand()*62),1)) as key

热心网友 时间：2022-05-08 05:45

设计表的时候 选择主键、递增就行了

热心网友 时间：2022-05-08 07:20

把最大值select出来
然后
alter table 表名 AUTO_INCREMENT=1136（最大值+1）;

热心网友 时间：2022-05-08 09:11

同上楼