DdXezrtF

1CREATE SCHEMA IF NOT EXISTS test;
2USE test;
3DROP TABLE IF EXISTS strict_test;
4CREATE TABLE strict_test(
5    i1 INT UNSIGNED NOT NULL AUTO_INCREMENT, 
6    c1 VARCHAR(10) NOT NULL, 
7    i2 TINYINT NOT NULL DEFAULT '1', 
8    PRIMARY KEY (i1)
9) ENGINE=InnoDB;
10SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION';
11\r
12SELECT @@sql_mode;
13INSERT INTO strict_test(i2) VALUES(2);
14SHOW WARNINGS;
15SELECT * FROM strict_test;
16
17SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
18\r
19SELECT @@sql_mode;
20INSERT INTO strict_test(i2) VALUES(3);
21SELECT * FROM strict_test;