Sequence Functions
Sequence functions in TiDB are used to return or set values of sequence objects created using the CREATE SEQUENCE statement.
| Function name | Feature description |
|---|---|
NEXTVAL() or NEXT VALUE FOR | Returns the next value of a sequence |
SETVAL() | Sets the current value of a sequence |
LASTVAL() | Returns the last used value of a sequence |
MySQL compatibility
MySQL does not support the functions and statements for creating and manipulating sequences as defined in ISO/IEC 9075-2.