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.