Sign inTry Free

SHOW WARNINGS

On this page

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?

On this page

Was this article helpful?