Diagnostics

Learn about diagnostics in programmatic compound statements. This section covers error handling and information retrieval within stored procedures and functions for effective debugging.

Diagnostics Area

Describes the diagnostics area that holds statement and condition information about errors, warnings, and notes produced by an SQL statement, including its properties and how it is populated and cleared.

GET DIAGNOSTICS

GET DIAGNOSTICS copies statement and condition information from the diagnostics area into user or local variables, reading properties such as NUMBER, RETURNED_SQLSTATE, MYSQL_ERRNO, and MESSAGE_TEXT.

SQLSTATE

Explains SQLSTATE, the five-character code identifying SQL error conditions by class and subclass, including the standard success, warning, and not-found classes and how they map to handler keywords.

_{This page is licensed: CC BY-SA / Gnu FDL}