PREVIOUS VALUE FOR sequence_name

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.3

SEQUENCEs are being introduced in MariaDB 10.3.

Syntax

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.

Description

Get last value generated from a sequence.

Notes

  • If the sequence has not yet been used by the connection, PREVIOUS VALUE FOR returns NULL
  • If a 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 affect on PREVIOUS VALUE FOR.
  • Previous values for all used sequences are stored per connection until connection ends.

See also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.