- drop table if exists t1;
- SET SQL_WARNINGS=1;
- create table t1 (this int unsigned);
- insert into t1 values (1);
- insert into t1 values (-1);
- Warnings:
- Warning 1264 Data truncated; out of range for column 'this' at row 1
- insert into t1 values ('5000000000');
- Warnings:
- Warning 1265 Data truncated for column 'this' at row 1
- select * from t1;
- this
- 1
- 0
- 4294967295
- drop table t1;