drop table if exists t1, t2; SET SQL_WARNINGS=1; create table t1 (a int); create table t1 (a int); ERROR 42S01: Table 't1' already exists show count(*) errors; @@session.error_count 1 show errors; Level Code Message Error 1050 Table 't1' already exists show warnings; Level Code Message Error 1050 Table 't1' already exists create table t2(a int) default charset qwerty; ERROR 42000: Unknown character set: 'qwerty' show count(*) errors; @@session.error_count 1 show errors; Level Code Message Error 1115 Unknown character set: 'qwerty' create table t (i); ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 show count(*) errors; @@session.error_count 1 show errors; Level Code Message Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 insert into t1 values (1); insert into t1 values ("hej"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 insert into t1 values ("hej"),("d�"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 Warning 1264 Out of range value for column 'a' at row 2 set SQL_WARNINGS=1; insert into t1 values ("hej"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 insert into t1 values ("hej"),("d�"); Warnings: Warning 1264 Out of range value for column 'a' at row 1 Warning 1264 Out of range value for column 'a' at row 2 drop table t1; set SQL_WARNINGS=0; drop temporary table if exists not_exists; Warnings: Note 1051 Unknown table 'not_exists' drop table if exists not_exists_table; Warnings: Note 1051 Unknown table 'not_exists_table' show warnings limit 1; Level Code Message Note 1051 Unknown table 'not_exists_table' drop database if exists not_exists_db; Warnings: Note 1008 Can't drop database 'not_exists_db'; database doesn't exist show count(*) warnings; @@session.warning_count 1 create table t1(id int); create table if not exists t1(id int); Warnings: Note 1050 Table 't1' already exists select @@warning_count; @@warning_count 1 drop table t1; create table t1(a tinyint, b int not null, c date, d char(5)); load data infile '../std_data_ln/warnings_loaddata.dat' into table t1 fields terminated by ','; Warnings: Warning 1263 Column was set to data type implicit default; NULL supplied for NOT NULL column 'b' at row 2 Warning 1265 Data truncated for column 'd' at row 3 Warning 1265 Data truncated for column 'c' at row 4 Warning 1261 Row 5 doesn't contain data for all columns Warning 1265 Data truncated for column 'b' at row 6 Warning 1262 Row 7 was truncated; it contained more data than there were input columns Warning 1264 Out of range value for column 'a' at row 8 select @@warning_count; @@warning_count 7 drop table t1; create table t1(a tinyint NOT NULL, b tinyint unsigned, c char(5)); insert into t1 values(NULL,100,'mysql'),(10,-1,'mysql ab'),(500,256,'open source'),(20,NULL,'test'); Warnings: Warning 1048 Column 'a' cannot be null Warning 1264 Out of range value for column 'b' at row 2 Warning 1265 Data truncated for column 'c' at row 2 Warning 1264 Out of range value for column 'a' at row 3 Warning 1264 Out of range value for column 'b' at row 3 Warning 1265 Data truncated for column 'c' at row 3 alter table t1 modify c char(4); Warnings: Warning 1265 Data truncated for column 'c' at row 1 Warning 1265 Data truncated for column 'c' at row 2 alter table t1 add d char(2); update t1 set a=NULL where a=10; Warnings: Warning 1048 Column 'a' cannot be null update t1 set c='mysql ab' where c='test'; Warnings: Warning 1265 Data truncated for column 'c' at row 4 update t1 set d=c; Warnings: Warning 1265 Data truncated for column 'd' at row 1 Warning 1265 Data truncated for column 'd' at row 2 Warning 1265 Data truncated for column 'd' at row 3 Warning 1265 Data truncated for column 'd' at row 4 create table t2(a tinyint NOT NULL, b char(3)); insert into t2 select b,c from t1; Warnings: Warning 1265 Data truncated for column 'b' at row 1 Warning 1265 Data truncated for column 'b' at row 2 Warning 1265 Data truncated for column 'b' at row 3 Warning 1048 Column 'a' cannot be null Warning 1265 Data truncated for column 'b' at row 4 insert into t2(b) values('mysqlab'); Warnings: Warning 1364 Field 'a' doesn't have a default value Warning 1265 Data truncated for column 'b' at row 1 set sql_warnings=1; insert into t2(b) values('mysqlab'); Warnings: Warning 1364 Field 'a' doesn't have a default value Warning 1265 Data truncated for column 'b' at row 1 set sql_warnings=0; drop table t1, t2; create table t1(a char(10)); alter table t1 add b char; set max_error_count=10; update t1 set b=a; Warnings: Warning 1265 Data truncated for column 'b' at row 1 Warning 1265 Data truncated for column 'b' at row 2 Warning 1265 Data truncated for column 'b' at row 3 Warning 1265 Data truncated for column 'b' at row 4 Warning 1265 Data truncated for column 'b' at row 5 Warning 1265 Data truncated for column 'b' at row 6 Warning 1265 Data truncated for column 'b' at row 7 Warning 1265 Data truncated for column 'b' at row 8 Warning 1265 Data truncated for column 'b' at row 9 Warning 1265 Data truncated for column 'b' at row 10 select @@warning_count; @@warning_count 50 set max_error_count=0; show variables like 'max_error_count'; Variable_name Value max_error_count 0 update t1 set b='hi'; Warnings: select @@warning_count; @@warning_count 50 show warnings; Level Code Message set max_error_count=65535; show variables like 'max_error_count'; Variable_name Value max_error_count 65535 set max_error_count=10; show variables like 'max_error_count'; Variable_name Value max_error_count 10 drop table t1; create table t1 (id int) engine=merge; Warnings: Warning 1266 Using storage engine MyISAM for table 't1' alter table t1 engine=merge; Warnings: Warning 1266 Using storage engine MyISAM for table 't1' drop table t1; set table_type=MYISAM; Warnings: Warning 1541 The syntax 'table_type' is deprecated and will be removed in MySQL 5.2. Please use 'storage_engine' instead create table t1 (a int); insert into t1 (a) values (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); update t1 set a='abc'; Warnings: Warning 1264 Out of range value for column 'a' at row 1 Warning 1264 Out of range value for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 Warning 1264 Out of range value for column 'a' at row 4 Warning 1264 Out of range value for column 'a' at row 5 Warning 1264 Out of range value for column 'a' at row 6 Warning 1264 Out of range value for column 'a' at row 7 Warning 1264 Out of range value for column 'a' at row 8 Warning 1264 Out of range value for column 'a' at row 9 Warning 1264 Out of range value for column 'a' at row 10 show warnings limit 2, 1; Level Code Message Warning 1264 Out of range value for column 'a' at row 3 show warnings limit 0, 10; Level Code Message Warning 1264 Out of range value for column 'a' at row 1 Warning 1264 Out of range value for column 'a' at row 2 Warning 1264 Out of range value for column 'a' at row 3 Warning 1264 Out of range value for column 'a' at row 4 Warning 1264 Out of range value for column 'a' at row 5 Warning 1264 Out of range value for column 'a' at row 6 Warning 1264 Out of range value for column 'a' at row 7 Warning 1264 Out of range value for column 'a' at row 8 Warning 1264 Out of range value for column 'a' at row 9 Warning 1264 Out of range value for column 'a' at row 10 show warnings limit 9, 1; Level Code Message Warning 1264 Out of range value for column 'a' at row 10 show warnings limit 10, 1; Level Code Message show warnings limit 9, 2; Level Code Message Warning 1264 Out of range value for column 'a' at row 10 show warnings limit 0, 0; Level Code Message show warnings limit 1; Level Code Message Warning 1264 Out of range value for column 'a' at row 1 show warnings limit 0; Level Code Message show warnings limit 1, 0; Level Code Message select * from t1 limit 0; a select * from t1 limit 1, 0; a select * from t1 limit 0, 0; a drop table t1;