Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Show Warnings Mysql Statement

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