Eine Einführung in

SQL

CREATE a table with an autonumber / sequence / identity / autoincrement

MySQL
An auto number field can provide a unique identifier where no other is available. These should be avoided if at all possible.
Execute tidy up code silently


Specific to MySQL
The may be only one AUTO_INCREMENT field per table. That field must be the primary key. CREATE TABLE