Reputation: 6298
How do I view the warning(s) after a SELECT query? The result of one query is:
Empty set, 1 warning (0.01 sec)
I am using MySQL via command line on Linux.
Upvotes: 23
Views: 12035
Reputation: 1260
Type \W in the MySQL command line.
\W
Upvotes: 6
Reputation: 321766
Using the SHOW WARNINGS syntax
SHOW WARNINGS;
Upvotes: 33