Mysql self-increasing id problem, how can the uninterrupted id be restored to continuous?

for example, there is a table now, and id increases itself.
has a total of 100 pieces of data. When deleting 2 pieces of data from 50 items and deleting 2 pieces of data where 80 items are deleted
how to make id continuous?

Python php
Mar.05,2022

depends on your needs, because the general self-increment id is related to joining other tables, so forced recovery of continuous self-increment is a disaster

if you ignore demand, there are two ways:

1 delete the self-incrementing field, and then rebuild 

ALTER TABLE `tablename` DROP COLUMN `id`;
ALTER TABLE `tablename` ADD `id` int(10) unsigned NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (`id`), AUTO_INCREMENT = 0 ROW_FORMAT = COMPACT;

2 resets the self-incrementing field values sequentially through the sql statement 

SET @i=0;
UPDATE `tablename` SET `id`=(@i:=@i+1);
ALTER TABLE `tablename` AUTO_INCREMENT=0;

Previous: The problem of promise red, green and blue lights realized by async/await

Next: Ask flutter to realize the method of downloading network pictures to the local area.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu