Sequences
This section is about sequence objects. For details about the storage engine, see Sequence Storage Engine.
A sequence is an object that generates a sequence of numeric values, as specified by the CREATE SEQUENCE statement. Sequences are an alternative to AUTO_INCREMENT when you want more control over how sequence numbers are generated.
Since a SEQUENCE caches values, it can sometimes be faster. Also, you can access the last value generated by all used sequences; it's not subjected to limitations of LAST_INSERT_ID( ).
See also Sequence Storage Engine.
Last updated
Was this helpful?