©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Sequence functions in MariaDB

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.

Generiert den nächsten Wert in einer Sequenz und gibt ihn zurück. Synonym für NEXT VALUE FOR sequence.
More about NEXTVAL Function
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
SETVALSETVAL(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: List of all MySQL and MariaDB built-in functions
Updated: 2023-09-22ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer