How is Sequences handled in MySQL?

[david]

Sequences are handled by primary key or by unique in which primary keys don't allow any duplicate rows and null values are not accepted. Sequences and unique allows multiple NULL values and duplicates values are not allowed.