如何填补“漏洞"?在自动增量字段中? [英] How to fill in the "holes" in auto-increment fields?

问题描述

我已经阅读了一些有关此的文章，但没有一篇涵盖这个问题.

I've read some posts about this but none cover this issue.

我想不可能，但是我还是要问.

I guess its not possible, but I'll ask anyway.

我有一个包含50.000个以上寄存器的表.这是一个旧表，其中进行了各种插入/删除操作.

I have a table with more than 50.000 registers. It's an old table where various insert/delete operations have taken place.

也就是说，大约有300个寄存器存在多个漏洞".即:...，1340，1341，1660，1661，1662，...

That said, there are various 'holes' some of about 300 registers. I.e.: ..., 1340, 1341, 1660, 1661, 1662,...

问题是.有没有简单/容易的方法来使新插入物填充这些孔"?

The question is. Is there a simple/easy way to make new inserts fill these 'holes'?

推荐答案

您需要此功能的原因是什么?您的数据库应该可以弥补这些空白，如果您接近密钥的最大大小，只需将其设置为未签名或更改字段类型即可.

What is the reason you need this functionality? Your db should be fine with the gaps, and if you're approaching the max size of your key, just make it unsigned or change the field type.

这篇关于如何填补“漏洞"?在自动增量字段中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！