Mysql查看warnings

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)