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.