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