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

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

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;