SEQUENCEs were introduced in MariaDB 10.3.
PREVIOUS VALUE FOR sequence_name
or
LASTVAL(sequence_name)
or in Oracle mode (SQL_MODE=ORACLE)
sequence_name.currval
PREVIOUS VALUE FOR
is IBM DB2 syntax while LASTVAL()
is PostgreSQL syntax.
Get last value in the current connection generated from a sequence.
PREVIOUS VALUE FOR
returns NULL
(same thing applies when the server is restarted, a new connection doesn't see a last value for an existing sequence). SEQUENCE
has been dropped and re-created then it's treated as a new SEQUENCE
and PREVIOUS VALUE FOR
will return NULL
. FLUSH TABLES
has no effect on PREVIOUS VALUE FOR
. PREVIOUS VALUE FOR
requires the SELECT privilege.
SELECT PREVIOUS VALUE FOR s; +----------------------+ | PREVIOUS VALUE FOR s | +----------------------+ | 100 | +----------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/previous-value-for-sequence_name/