For what it may be worth, executing the same commands into MySQL 5.0.15-nt-max (Win XP Pro) the following it received: mysql> create table test (i1 int); Query OK, 0 rows affected (0.41 sec) mysql> insert into test values (123913284723498723423); ERROR 1264 (22003): Out of range value adjusted for column (i1) at row 1 mysql> select * from test; Empty set (0.03 sec) Finally an improvement! ============================================================ -----Original Message----- mysql> create table test (i1 int); Query OK, 0 rows affected (0.07 sec) mysql> insert into test values (123913284723498723423); Query OK, 1 row affected, 2 warnings (0.07 sec) mysql> select * from test; +------------+ | i1 | +------------+ | 2147483647 | +------------+ 1 row in set (0.00 sec) And other fun things. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
