> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/programmatic-compound-statements/declare-condition.md).

# DECLARE CONDITION

## Syntax

```bnf
DECLARE condition_name CONDITION FOR condition_value

condition_value:
    SQLSTATE [VALUE] sqlstate_value
  | mysql_error_code
```

## Description

The `DECLARE ... CONDITION` statement defines a named error condition. It specifies a condition that needs specific handling and associates a name with that condition. Later, the name can be used in a [DECLARE ... HANDLER](/docs/server/reference/sql-statements/programmatic-compound-statements/declare-handler.md), [SIGNAL](/docs/server/reference/sql-statements/programmatic-compound-statements/signal.md) or [RESIGNAL](/docs/server/reference/sql-statements/programmatic-compound-statements/resignal.md) statement (as long as the statement is located in the same [BEGIN ... END](/docs/server/reference/sql-statements/programmatic-compound-statements/begin-end.md) block).

Conditions must be declared after [local variables](/docs/server/reference/sql-statements/programmatic-compound-statements/declare-variable.md), but before [CURSORs](/docs/server/reference/sql-statements/programmatic-compound-statements/programmatic-compound-statements-cursors.md) and [HANDLERs](/docs/server/reference/sql-statements/programmatic-compound-statements/declare-handler.md).

A condition\_value for `DECLARE ... CONDITION` can be an [SQLSTATE](/docs/server/reference/sql-statements/programmatic-compound-statements/programmatic-compound-statements-diagnostics/sqlstate.md) value (a 5-character string literal) or a MySQL error code (a number). You should not use `SQLSTATE` value '00000' or MySQL error code 0, because those indicate success rather than an error condition. If you try, or if you specify an invalid `SQLSTATE` value, an error like this is produced:

```sql
ERROR 1407 (42000): Bad SQLSTATE: '00000'
```

For a list of `SQLSTATE` values and MariaDB error codes, see [MariaDB Error Codes](/docs/server/reference/error-codes/mariadb-error-code-reference.md).

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}