Note
This variable is available starting with V1.4.
Description
identity and last_insert_id are synonyms. You can execute the select @@identity statement to query the value of identity.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to obtain the value of a Session system variable.Modify variables
systenants and all user tenants can directly modify the value of a Session system variable of their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Uint |
| Default value | 0 |
| Value range | [0, 18446744073709551615] |
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Update the value of the last auto-increment field to 1001.
obclient> SET identity= 1001;