Syntax:
SHOW WARNINGS [LIMIT [offset,] row_count]
SHOW COUNT(*) WARNINGS

SHOW WARNINGS shows the error, warning, and note messages that resulted
from the last statement that generated messages, or nothing if the last
statement that used a table generated no messages. A related statement,
SHOW ERRORS, shows only the errors. See [HELP SHOW ERRORS].

The list of messages is reset for each new statement that uses a table.

The SHOW COUNT(*) WARNINGS statement displays the total number of
errors, warnings, and notes. You can also retrieve this number from the
warning_count variable:

SHOW COUNT(*) WARNINGS;
SELECT @@warning_count;

The value of warning_count might be greater than the number of messages
displayed by SHOW WARNINGS if the max_error_count system variable is
set so low that not all messages are stored. An example shown later in
this section demonstrates how this can happen.

The LIMIT clause has the same syntax as for the SELECT statement. See
[HELP SELECT].

URL: http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html

