SHOW LAST INSERT

Description

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

Syntax

SHOW LAST INSERT

Example of returned result:

     TransactionId: 64067
             Label: insert_ba8f33aea9544866-8ed77e2844d0cc9b
          Database: default_cluster:db1
             Table: t1
TransactionStatus: VISIBLE
        LoadedRows: 2
      FilteredRows: 0

Return Value

• TransactionId: transaction id
• Label: the label corresponding to the insert task
• Database: the database corresponding to insert
• Table: the table corresponding to insert
• TransactionStatus: transaction status
  • PREPARE: preparation stage
  • PRECOMMITTED: Pre-commit stage
  • COMMITTED: The transaction succeeded, but the data was not visible
  • VISIBLE: The transaction succeeded and the data is visible
  • ABORTED: Transaction failed
• LoadedRows: Number of imported rows
• FilteredRows: The number of rows being filtered

Examples

Keywords

SHOW, LAST, INSERT

Best Practice