自动编号数据类型 [英] Autonumber Data type
问题描述
自动编号的最大数量是多少？是否可以自动重复使用已达到最大数量后已删除的前一个数字？
What is the max number autonumber will count to? Can it automatically re-use previous numbers which have been deleted once it has reached the max number?
推荐答案
什么自动编号的最大数量是多少？是否可以自动重复使用已达到最大数量后删除的旧号码？
What is the max number autonumber will count to? Can it automatically re-use previous numbers which have been deleted once it has reached the max number?
由于自动编号字段本质上是一个长整型数据类型，如果旧神经元仍在工作，我认为长整数的最大值是2,147,483,647。据我所知，已删除的数字永远无法回收。
Since an AutoNumber Field is essentially a Long Integer Data Type, and if the old neurons are still working, I think the maximum value for a Long Integer is 2,147,483,647. To the best of my knowledge, numbers which have been deleted can never be reclaimed.
因为自动编号字段本质上是一个长整数数据输入，如果旧的神经元仍在工作，我认为Long Integer的最大值是2,147,483,647。据我所知，已删除的数字永远无法回收。
Since an AutoNumber Field is essentially a Long Integer Data Type, and if the old neurons are still working, I think the maximum value for a Long Integer is 2,147,483,647. To the best of my knowledge, numbers which have been deleted can never be reclaimed.
我有一个数据库，我使用自动编号为记录分配唯一标识符。但是，数据库要求每天插入和删除大约10000条记录。如果我每天插入和删除这么多记录，可以理解我将很快用完这个自动编号标识符。有没有办法解决这个问题，这样我就可以使用自动编号为每条记录自动生成i唯一标识符而不会耗尽自动编号使用？
I have a database in which I am using autonumber to assign unique identifiers to records. However the database requires the insert and delete of approx 10000 records daily. If i am inserting and deleting this many records daily, one can appreciate I will run out of this autonumber identifier very quickly. Is there a way round this so that I can automatically generate i unique identifier for each record using autonumber without the possibility of running out of autonumbers to use?
我有一个数据库，我在其中使用自动编号为记录分配唯一标识符。但是，数据库要求每天插入和删除大约10000条记录。如果我每天插入和删除这么多记录，可以理解我将很快用完这个自动编号标识符。有没有办法解决这个问题，以便我可以使用自动编号为每条记录自动生成i唯一标识符，而不会耗尽自动编号使用？
I have a database in which I am using autonumber to assign unique identifiers to records. However the database requires the insert and delete of approx 10000 records daily. If i am inserting and deleting this many records daily, one can appreciate I will run out of this autonumber identifier very quickly. Is there a way round this so that I can automatically generate i unique identifier for each record using autonumber without the possibility of running out of autonumbers to use?
如果在每次删除记录后压缩并修复数据库，数字将被重置。但是，此操作将关闭然后重新打开数据库。
If you compact and repair the database each time after deleting the records the numbers will be reset. However, this operation will close and then reopen the database.
这篇关于自动编号数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
