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;