2010-09-18 18:42
话说用了这么久Mysql了,Error见的多了,Warnings倒还真没注意,今天突然遇到一个
Query OK, 4 rows affected, 5 warnings (0.00 sec)
Records: 4 Duplicates: 0 Warnings: 5
居然有5个Warning,但是它没有显示出来,一时不知道怎么让它显示出来...
于是随便试了试下面的语句,居然就显示出来了,哈哈。不过倒也可以理解...Mysql里面的Show语句确实挺强大滴,记下来咯~~~~
mysql> show warnings
-> ;
--------- ------ -------------------------------------------------
| Level | Code | Message |
--------- ------ -------------------------------------------------
| Warning | 1265 | Data truncated for column 'newsType' at row 1 |
| Warning | 1265 | Data truncated for column 'title' at row 2 |
| Warning | 1265 | Data truncated for column 'newsType' at row 2 |
| Warning | 1265 | Data truncated for column 'title' at row 3 |
| Warning | 1265 | Data truncated for column 'updateTime' at row 3 |
--------- ------ -------------------------------------------------
5 rows in set (0.00 sec)