以给定值启动自动编号 [英] Start Autonumber at a given value

问题描述

是否可以将自动编号设置为从给定值开始？我希望所有数字从500开始并从那里增加1。

Is it possible to set an autonumber to start from a given value? I would like all numbers to start at 500 and increase by 1 from there.

推荐答案

这不是一件容易的事情，也不是任何人想要的东西如果他们理解自动编号就行了。


您似乎正在寻找的是一种让密钥从特定点开始并从那里顺序进行的方法。这不是你想要使用自动编号的东西。

This is not an easy thing to do, nor is it something anyone would want to do if they understood autonumbers.

What you seem to be looking for is a way to have keys starting from a particular point and going sequentially from there. This is not something you would want to use autonumbers for.

感谢NeoPa。我正在尝试调整已经存在的数据库，因为大多数结构都是我想要的。但是我想更改主标识符（当前被指定为自动编号），以便我可以轻松识别出的条目 - 任何想法？

Thanks NeoPa. I am trying to adapt a database that already exists as the majority of the structure is as I want it. However I would like to change the main identifier (currently assigned as an autonumber) so that the entries I make are easily identifiable - any ideas?

我接近这个的方法是转换自动编号字段为长整数（兼容数据类型）并控制自己分配数字。


具体如何以及在何处完成取决于数据添加到何时何地那张桌子。

The way I would approach this is by converting the autonumber field to a long integer (compatible data type) and take control of assigning the number myself.

Exactly how and where this would be done depends on where and when data is EVER added to that table.

这篇关于以给定值启动自动编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！