NEXT VALUE for sequence_name
NEXT VALUE FOR sequence
or in Oracle mode (SQL_MODE=ORACLE)
NEXT VALUE FOR is ANSI SQL syntax while
NEXTVAL() is PostgreSQL syntax.
Generate next value for a
- You can greatly speed up
NEXT VALUEby creating the sequence with the
CACHEoption. If not, every
NEXT VALUEusage will cause changes in the stored
- When using
NEXT VALUEthe value will be reserved at once and will not be reused, except if the
SEQUENCEwas created with
CYCLE. This means that when you are using
SEQUENCEs you have to expect gaps in the generated sequence numbers.
- If one updates the
SEQUENCEwith SETVAL() or ALTER SEQUENCE ... RESTART,
NEXT VALUE FORwill notice this and start from the next requested value.
- FLUSH TABLES will close the sequence and the next sequence number generated will be according to what's stored in the
SEQUENCEobject. In effect, this will discard the cached values.
- A server restart (or closing the current connection) also causes a drop of all cached values. The cached sequence numbers are reserved only for the current connection.
NEXT VALUErequires the
MariaDB starting with 10.3.3
- You can also use
NEXT VALUE FOR sequencefor column
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.