# SHOW ERRORS

Displays errors as a result of execution of an invalid statement.

## Syntax

```
SHOW ERRORS;

```

```
SELECT @@error_count;

```

## Remarks

* `SHOW ERRORS` is a diagnostic statement that displays error information as a result of an invalid statement execution.
* `@@error_count` variable displays the total number of errors.
* This command can be run on any SingleStore node (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Examples

The following example shows the errors and its count after an invalid `INSERT` query is run.

```sql
CREATE TABLE t1 (a TINYINT NOT NULL, B CHAR);

```

```output

Query OK, 0 rows affected (1.25 sec)

```

```sql
INSERT INTO t1 VALUES(10,'mysql'), (NULL, 'test'), (300,'xyz');

```

```output

ERROR 1048 (23000): Leaf Error (127.0.0.1:3307): Column 'a' cannot be null

```

```sql
SHOW ERRORS;

```

```output

+-------+------+--------------------------------------------------------+
| Level | Code | Message                                                |
+-------+------+--------------------------------------------------------+
| Error | 1048 | Leaf Error (127.0.0.1:3307): Column 'a' cannot be null |
+-------+------+--------------------------------------------------------+
1 row in set (0.00 sec)

```

```sql
SELECT @@error_count;

```

```output

+---------------+
| @@error_count |
+---------------+
|             1 |
+---------------+
1 row in set (0.55 sec)

```

***

Modified at: May 12, 2026

Source: [/db/v9.1/reference/sql-reference/show-commands/show-errors/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-errors/)

(An index of the documentation is available at /llms.txt)