mysql 数据库主键初始化（主键超过最大值）

1、删除主键

ALTER TABLE sys_themis_config_site DROP PRIMARY KEY;

ALTER TABLE sys_themis_config_site ADD id
BIGINT(20) NOT NULL COMMENT ‘主键’ FIRST;

2、显⽰⾏号的sql

SELECT
@r := @r + 1 AS row_num,a.*
FROM sys_themis_config_site a, (SELECT @r := 0) b

3、根据条件更新主键

UPDATE sys_themis_config_site mmw1
INNER JOIN (
SELECT
@r := @r + 1 AS row_num,
mmw2.site_id,
mmw2.rule_type
FROM
sys_themis_config_site mmw2,
(SELECT @r := 0) b
) tb ON mmw1.site_id = tb.site_id
AND mmw1.rule_type = tb.rule_type
SET mmw1.id = tb.row_num;

4、添加主键

ALTER TABLE sys_themis_config_site
ADD PRIMARYKEY (‘id’);