An employee
An employee

Reputation: 6298

How do I view the warning(s) after a SELECT query using the MySQL command line?

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

Answers (2)

Carter
Carter

Reputation: 1260

Type \W in the MySQL command line.

Upvotes: 6

Greg
Greg

Reputation: 321766

Using the SHOW WARNINGS syntax

SHOW WARNINGS;

Upvotes: 33

Related Questions