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.