MySQL Auto Increment Tutorial

MySQL Auto Increment

Generate sequential numeric identifiers automatically.

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

When an INSERT omits id, MySQL generates a value for the new row.