MariaDB starting with 10.3

CREATE SEQUENCE was introduced in MariaDB 10.3.

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( ).

This section is about sequence objects. For details about the storage engine, see Sequence Storage Engine.