{ “title”: “SHOW LAST INSERT”, “language”: “en”, “description”: “This syntax is used to view the result of the latest insert operation in the current session connection” }

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

Example

Keywords

SHOW, LAST, INSERT

Best Practice