SEQUENCEs were 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 in the current connection generated from a
sequence.
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 effect on PREVIOUS VALUE FOR.
Previous values for all used sequences are stored per
connection until connection ends.
 
PREVIOUS VALUE FOR requires the SELECT privilege.
 
Example
 
SELECT PREVIOUS VALUE FOR s;
 
+----------------------+
| PREVIOUS VALUE FOR s |
+----------------------+
| 100 |
+----------------------+
 


URL:
https://mariadb.com/kb/en/previous-value-for-sequence_name/