AUTO INCREMENT Field Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table. Often this is the primary key field that we would like to be ...

This column type will automatically assign an integer value for each new row, starting from 1 and incrementing by 1 for each new row. For example, to create a table with an autoincrement primary key, ...