Available since: v3.0.0
These functions can be used to work with sequences.
Function | Description |
|---|---|
sequence::next() | Returns the next value in a sequence. |
sequence::next
The sequence::next function returns the next value in a sequence.
API DEFINITION
sequence::next($seq_name: string) -> int/**[test]
[[test.results]]
value = "NONE"
[[test.results]]
value = "100"
*/
DEFINE SEQUENCE mySeq2 BATCH 1000 START 100 TIMEOUT 5s;
sequence::nextval('mySeq2');
-- 100