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
NEXT VALUEby creating the sequence with the
CACHEoption. If not, every
NEXT VALUEusage will cause changes in the stored
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.
SEQUENCEwith SETVAL() or ALTER SEQUENCE ... RESTART,
NEXT VALUE FORwill notice this and start from the next requested value.
SEQUENCEobject. In effect, this will discard the cached values.
NEXT VALUErequires the
NEXT VALUE FOR sequencefor column
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.