SHOW LAST INSERT

description

This syntax is used to view the result of the last insert operation in the current session connection.

Syntax:

1. SHOW LAST INSERT

Example of return result.

1. TransactionId: 64067
2. Label: insert_ba8f33aea9544866-8ed77e2844d0cc9b
3. Database: default_cluster:db1
4. Table: t1
5. TransactionStatus: VISIBLE
6. LoadedRows: 2
7. FilteredRows: 0
  • TransactionId: transaction id
  • Label: label corresponding to the insert task
  • Database: the database corresponding to the insert
  • Table: the table corresponding to the insert
  • TransactionStatus: the status of the transaction
  • PREPARE: preparation phase
  • PRECOMMITTED: Pre-committed stage
  • COMMITTED: The transaction is successful, but the data is not visible
  • VISIBLE: The transaction is successful and the data is visible
  • ABORTED: The transaction failed.
  • LoadedRows: Number of rows imported
  • FilteredRows: number of rows filtered

example

keyword

1. SHOW, LAST, INSERT