How to create MySQL table with AUTO_INCREMENT

Last updated on August 8th, 2022 at 11:11 am

The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows:

Here we are creating a simple TABLE named login_details, with olumns ID, uniqid, Manager, email, Account_Name.

AUTO_INCREMENT is assigned to column named ID. By doing this whenever you insert a new row to the table login_details the numerical value within the column ID will get incremented automatically starting with 1 (one) if no value is specified for the ID column.

CREATE TABLE login_details (
     ID MEDIUMINT NOT NULL AUTO_INCREMENT,
     uniqid MEDIUMINT,
     Manager CHAR(30),
     email VARCHAR(255),
     Account_Name VARCHAR(255),
     PRIMARY KEY (id)
) ENGINE=MyISAM;