Do I need to reuse the numeric primary keys of deleted records in the database for future new records?

Question

For example, if I have a field with an automatic number, I add new records without specifying this field, and let the database engine select it for me.
So, will he choose the number of the deleted record? If yes, when?

// SQL Server, MySQL.//

Follow-up question: What happens when the numbers for primary keys end in the database engine?

Answer 1

. , , ( !)

Answer 2

AFAIK, MySQL:

AUTO_INCREMENT InnoDB:

InnoDB . , InnoDB INSERT , .

. Innodb auto_increment.:

: innodb auto_increment .

Answer 3

. , , .

Answer 4

, , .

- , Oracle, - , .

, , .

Answer 5

. , . (set identity_insert on SQL Server) , , .

Answer 6

:

... " Oracle Sequences"

... " autonumber MySQL"

... ..

Answer 7

, . (IN MSSQL ), :

- , ,

CHECKIDENT DBCC ([TableName], RESEED, [NumberYouWantToStartAt])

, , ... :)

Answer 8

MySQL , truncate delete from where ( MySQL truncate).

Answer 9

, , .

, GUID , Guid , , Guid , , , .

Answer 10

MySQL id-.

- . : , ..

, ... , , , , , , , .

, , , , , , , . .

Answer 11

, , account_id - arghhhh!!