docs/sql-manual/sql-statements/data-modification/DML/SHOW-LAST-INSERT.md

---
{
    "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

```sql
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