SQL AUTO INCREMENT  allows a unique number to be generated when a new record is inserted into a table.

It usually used with primary keys

Example

CREATE TABLE IF NOT EXISTS `users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`uid`)
)