Example of Show Warnings Mysql Statement:
DROP TABLE IF EXISTS no_such_table;
SHOW WARNINGS;
CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)) TYPE=MyISAM;
SHOW WARNINGSG
INSERT INTO t1 VALUES(10,'mysql'),(NULL,'test'),(300,'Open Source');
SHOW WARNINGSG
SHOW VARIABLES LIKE 'max_error_count';
Example of Mysql Show Warnings
SHOW WARNINGS [LIMIT [offset,] row_count]
SHOW COUNT(*) WARNINGS