 MySQL and MariaDB - Overview of the Sequence functions | MariaDB introduced support for sequences and sequence functions in version 10.3, allowing users to create and manage sequences with ease. Sequence functions can be useful when working with sequences in MariaDB. They can be used to manage and retrieve values from sequences in an efficient and convenient manner. However, it is important to note that not all versions of MariaDB support sequence functions, so it is important to check the version before using these functions.
These functions are not available in MySQL. | | Sequenz-Funktionen |
| | NEXTVAL | NEXTVAL(Sequence) | Generiert den nächsten Wert in einer Sequenz und gibt ihn zurück. Synonym für NEXT VALUE FOR sequence.
More about NEXTVAL Function | | LASTVAL | LASTVAL(Sequence) | Gibt den letzten Wert in einer aktuellen Verbindung zurück, der in einer Sequenz generiert wurde. Synonym für PREVIOUS VALUE FOR sequence.
More about LASTVAL Function | | SETVAL | SETVAL(Sequence, Value [, Reserved] [, Cycle]) | Setzt den nächsten Wert, der von einer Sequenz zurückgegeben werden soll und gibt ihn zurück.
More about SETVAL Function |
|
|
| | See also: |
|
|
|
