mysql> create table test (test numeric(4,2));
Query OK, 0 rows affected (0.10 sec)

mysql> insert into test (test) values (10000000);
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;
+---------+------+---------------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------------+
| Warning | 1264 | Data truncated; out of range for column 'test' at row 1 |
+---------+------+---------------------------------------------------------+
1 row in set (0.02 sec)

mysql> SELECT VERSION();
+------------------+
| VERSION() |
+------------------+
| 4.1.15-log |
+------------------+



mysql> SET SQL_MODE="Traditional";
Query OK, 0 rows affected (0.00 sec)

mysql> create table test (test numeric(4,2));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test (test) values (10000000);
ERROR 1264 (22003): Out of range value adjusted for column 'test' at row 1

mysql> SELECT COUNT(*) FROM test;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)

mysql> SELECT VERSION();
+---------------------+
| VERSION() |
+---------------------+
| 5.0.15-rc-debug-log |
+---------------------+
1 row in set (0.00 sec)

Съдържаниет е скрито
Влезте за да го видите