identity is synonymous with the last_insert_id variable and can be queried by using select @@identity.
| Attribute | Description |
|---|---|
| Type | uint |
| Default value | 0 |
| Value range | [0, 18446744073709551615] |
| Applicable scope | Session |
identity
share
Previous topic
All Products
OceanBase Database
SQL - V4.1.0Enterprise Edition
Download PDF
Overview Differences between the features of the Enterprise Edition and the Community Edition System architecture Overview SQL data types Built-in functions System views Compatibility with MySQL Limitations Get started with OceanBase Database Before you begin Basic SQL operations (MySQL mode) Basic SQL operations (Oracle mode) Build a Python application Build a Java application Build a C application Build a Go application Build a Python application Build a Java application Build a C application Try out operational OLAP Try out parallel import and data compression Try out the multi-tenant feature Video tutorials Overview OceanBase cluster deployment solutions Deployment process Overview Deploy OceanBase Database in a Kubernetes cluster Clean up an old cluster About data migration Migrate data from a MySQL database to OceanBase Database by using mydumper and myloader Use DBCAT to migrate schemas from a MySQL database to OceanBase Database Use DataX to migrate table data from a MySQL database to OceanBase Database Use CloudCanal to migrate data from a MySQL database to OceanBase Database Use Canal to synchronize data from a MySQL database to OceanBase Database Use Flink CDC to synchronize data from a MySQL database to OceanBase Database Use ChunJun to migrate data from a MySQL database to OceanBase Database Use DBCAT to migrate schemas from OceanBase Database to a MySQL database Use DataX to migrate table data from OceanBase Database to a MySQL database Synchronize data from OceanBase Database to a MySQL database using Canal Migrate data from a MySQL OceanBase database to a MySQL database using CloudCanal Migrate data from OceanBase Database to a MySQL database using Flink CDC Migrate data from a MySQL database in OceanBase Database to a MySQL database using ChunJun Use DBCAT to migrate schemas from an Oracle database to OceanBase Database Use DataX to migrate table data from an Oracle database to OceanBase Database Use DBCAT to migrate schemas from OceanBase Database to an Oracle database Use DataX to migrate table data from OceanBase Database to an Oracle database Use DBCAT to migrate DB2 LUW table schemas to OceanBase Database Use DataX to migrate CSV files to OceanBase Database Import data by using the LOAD DATA statement Import data from SQL files to OceanBase Database Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database clusters Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in an OceanBase cluster Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database clusters Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database Migrate data between tables Migrate resource units Export data by using OUTFILE statements Overview Import data in bypass mode by using the LOAD DATA statement Import data in bypass mode by using the INSERT INTO SELECT statement Log on to an OceanBase Database tenant Overview Cluster parameters Tenant introduction Tenant capacity Tenant types User tenants System variables of a tenant What is replica Traffic distribution Data distribution What is high availability Flashback queries Overview Introduction to physical backup and restore Deploy NFS Overview Cases Overview Log levels Log stability Log control Log metrics Troubleshoot SQL execution errors Overall architecture of OceanBase Database Overview Common statistics events Reserved keywords (MySQL mode) Reserved keywords (Oracle mode) OMA OMS OCP OCP Express ODC OAT Products SQL statements Deployment