Making a Column Autoincrement the Value Itself in MySQL

You can create a column in a table in MySQL and make that column to auto-increment the value every time a record is inserted in the table.

The catch is that you need to ensure that the column you are trying to auto-increment should also be a key column.

Sample table

CREATE TABLE `Details` (
   `ai` INT(11) NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(50) NULL DEFAULT NULL ,
   `address` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_bin',
   PRIMARY KEY (`ai`)
)
COLLATE='utf8_bin'
ENGINE=InnoDB;

Please note that the column ai is also the PRIMARY KEY and hence AUTO_INCREMENT is allowed.