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 DROP TABLE t_test; DROP sequence sq CREATE TABLE t_test( id INTEGER AUTO_INCREMENT PRIMARY KEY, name VARCHAR(10) ); INSERT INTO t_test(name) VALUES ('Andrew'); INSERT INTO t_test(name) VALUES ('Gordon'); SELECT * FROM t_test;
Specific to MySQL
The may be only one AUTO_INCREMENT field per table. That field must be the primary key. CREATE TABLE