|
Тема |
Re:Кой е МъСЯЛ? [re: bandy] |
|
Автор |
salle (един такъв) |
|
Публикувано | 27.01.06 09:03 |
|
|
То си пише ама някой трябва да чете ...
mysql> CREATE TABLE d (d DATE);
Query OK, 0 rows affected (0.03 sec)
mysql> INSERT INTO d VALUES('2006-02-30');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+---------+------+----------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------+
| Warning | 1265 | Data truncated for column 'd' at row 1 |
+---------+------+----------------------------------------+
mysql> SET SQL_MODE=TRADITIONAL;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO d VALUES('2006-02-30');
ERROR 1292 (22007): Incorrect date value: '2006-02-30' for column 'd' at row 1
|
| |
|
|
|