Portable SQL/Statements/IDs/Generating IDs
From Linuxnetworks
MySQL
CREATE TABLE table ( id <type> NOT NULL AUTO_INCREMENT );
The column types can be:
- TINYINT
- SMALLINT
- INTEGER
- BIGINT
SQLite
CREATE TABLE table ( id INTEGER NOT NULL AUTOINCREMENT );
Only INTEGER column types are allowed for generated IDs.
