如何填“洞"在自增字段中? [英] 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屋！