The diagnostics area contains information about the error conditions which were produced by an SQL statement, as well as some information about the statement which generated them.
| Title | Description |
|---|---|
| Error Codes | MariaDB error codes and SQLSTATE codes |
| DECLARE CONDITION | For declaring a named error condition (SQLSTATE or error code). |
| DECLARE HANDLER | Construct to declare how errors are handled. |
| Diagnostics Area | A description of the diagnostics area and how it is populated. |
| GET DIAGNOSTICS | Copy information about the diagnostics area into variables. |
| RESIGNAL | Used to send a SIGNAL again for the previous error. |
| SHOW ERRORS | Displays errors. |
| SHOW WARNINGS | Displays errors, warnings and notes. |
| SIGNAL | May be used to produce a custom error message. |
| SQL Error Log Plugin | Records SQL-level errors to a log file. |
| SQLSTATE | A string which identifies a condition's class and subclass |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/programmatic-compound-statements-diagnostics/