Skip to main content
autoincrement

autoincrement

1 6.4
A database feature that gives each new record a unique number
  • noun
  • /ˌɔːtoʊˈɪnkrəˌmɛnt/
  • Specialized
: autoincremento
  • If you use autoincrement, you do not need to specify the primary key value yourself.

Examples

  • The database uses an autoincrement feature to assign a unique identifier to each new entry.

  • The autoincrement feature saves time by automatically assigning IDs to new records.

  • Many database systems support autoincrement columns for unique identification.

  • The autoincrement feature helps maintain unique IDs.

  • You can set the autoincrement option in your database.

  • You must enable the autoincrement option for the primary key in your database table.

  • When a new record is inserted, the autoincrement field automatically provides the next available number.

Surface Forms

autoincrement singular

Morphology

autoincrement = increment (transparent) = auto + increment

The feature is straightforwardly understood as a database increment that happens automatically.

Etymology

Autoincrement combines auto- ('self' or 'automatic') and increment ('increase'), so as a noun it names the automatic 'increase' that gives new ID numbers to records in a database.