# **LAST_QUERY_ID()**

## **Grammar Description**

Returns the ID of the specified query in the current session. If no query is specified, the most recently executed query is returned.

## **Grammar Structure**

```text
> LAST_QUERY_ID([ <num> ])
```

### Parameter definition

-**num**: Specify the query to be returned based on the location of the query in the current session. The default is -1.

### User definition

num is a positive number, which starts with the first query executed in the session. For example:

- `LAST_QUERY_ID(1): Returns the first query.

- `LAST_QUERY_ID(2): Returns the second query.

- `LAST_QUERY_ID(6)`: Returns the sixth query.

num is a negative number, that is, it starts with the most recently executed query in the session. For example:

- `LAST_QUERY_ID(-1)`: Returns the most recently executed query (equivalent to LAST_QUERY_ID()).

- `LAST_QUERY_ID(-2)`: Returns the second query that was recently executed.

## **Example**

```text
mysql> SELECT LAST_QUERY_ID(-1);
+---------------------------------------------+
| last_query_id(-1) |
+---------------------------------------------+
| af974680-b1b5-11ed-8eb9-5ad2460dea4f |
+---------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT LAST_QUERY_ID();
+---------------------------------------------+
| last_query_id() |
+---------------------------------------------+
| 550e4d44-b1b5-11ed-8eb9-5ad2460dea4f |
+---------------------------------------------+
1 row in set (0.00 sec)
```