SHOW WARNINGS

Display warnings as a result of an invalid statement execution.

Syntax

SHOW WARNINGS
SELECT @@warning_count;

Remarks

  • SHOW WARNINGS is a diagnostic statement that displays warning information as a result of an invalid statement execution in the current session.

  • @@warning_count variable displays the total number of warnings.

  • See the Permission Matrix for the required permission.

Example

The following example shows the warnings and its count after an invalid WHERE statement is run.

SELECT * FROM t5 WHERE geography_intersects('point(0 0)', 'TestValue');
Empty set, 1 warning (0.46 sec)
SHOW WARNINGS;
+---------+------+----------------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------------+
| Warning | 1862 | You have an error in your WKT syntax at position 0 |
+---------+------+----------------------------------------------------+
1 row in set (0.00 sec)
SELECT @@warning_count;
+-----------------+
| @@warning_count |
+-----------------+
| 1 |
+-----------------+
1 row in set (0.57 sec)

Last modified: January 11, 2023

Was this article helpful?