Eine Einführung in

SQL

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

Mimer SQL
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 SEQUENCE sq; CREATE TABLE t_test( id INTEGER PRIMARY KEY DEFAULT NEXT_VALUE OF sq, name VARCHAR(10) ); INSERT INTO t_test(name) VALUES ('Andrew'); INSERT INTO t_test(name) VALUES ('Gordon'); SELECT * FROM t_test;
Specific to Mimer SQL
We create a `SEQUENCE` and ensure that the autonumber field defaults top the next value.