SQL - Auto Increment / Identity

Overview

MySQL uses AUTO_INCREMENT, SQL Server uses IDENTITY or SEQUENCE, SQLite uses INTEGER PRIMARY KEY (optionally AUTOINCREMENT) which maps to the rowid.

CREATE TABLE t (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50)
);
INSERT INTO t(name) VALUES('A');
SELECT LAST_INSERT_ID();

CREATE TABLE t (
  id INT IDENTITY(1,1) PRIMARY KEY,
  name NVARCHAR(50)
);
INSERT INTO t(name) VALUES(N'A');
SELECT SCOPE_IDENTITY();

CREATE TABLE t (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT
);
INSERT INTO t(name) VALUES('A');
SELECT last_insert_rowid();

id
1