47483647,2147483648,2147483648); SELECT * FROM ints; +------------+------------+------------+ | a | b | c | +------------+------------+------------+ | -10 | 10 | 0000000010 | | 2147483647 | 2147483648 | 2147483648 | +------------+------------+------------+ With strict_mode unset, the default until MariaDB 10.2.3: INSERT INTO ints VALUES (-10,-10,-10); Query OK, 1 row affected, 2 warnings (0.10 sec) Warning (Code 1264): Out of range value for column 'b' at row 1 Warning (Code 1264): Out of range value for column 'c' at row 1 INSERT INTO ints VALUES (-10,10,-10); Query OK, 1 row affected, 1 warning (0.08 sec) Warning (Code 1264): Out of range value for column 'c' at row 1 INSERT INTO ints VALUES (-10,10,10); INSERT INTO ints VALUES (2147483648,2147483648,2147483648); Query OK, 1 row affected, 1 warning (0.07 sec) Warning (Code 1264): Out of range value for column 'a' at row 1 INSERT INTO ints VALUES (2147483647,2147483648,2147483648); SELECT * FROM ints; +------------+------------+------------+ | a | b | c | +------------+------------+------------+ | -10 | 0 | 0000000000 | | -10 | 10 | 0000000000 | | -10 | 10 | 0000000010 | | 2147483647 | 2147483648 | 2147483648 | | 2147483647 | 2147483648 | 2147483648 | +------------+------------+------------+ URL: https://mariadb.com/kb/en/int/https://mariadb.com/kb/en/int/