在mysql更新的时候 有一个warning报错 :
mysql> UPDATE TB_SYS_BRANCH SET VR_SYSBR_CODE="\$!\\''##" where ID_SYS_BRANCH=1;
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 1查看:
mysql> select VR_SYSBR_CODE from TB_SYS_BRANCH where ID_SYS_BRANCH=1;
+---------------+
| VR_SYSBR_CODE |
+---------------+
| $!\ |
+---------------+
1 row in set (0.00 sec)
也不是我想插入的内容请大家帮忙看下怎么回事如何查看这个语句的warning信息?
感谢
mysql> UPDATE TB_SYS_BRANCH SET VR_SYSBR_CODE="\$!\\''##" where ID_SYS_BRANCH=1;
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 1查看:
mysql> select VR_SYSBR_CODE from TB_SYS_BRANCH where ID_SYS_BRANCH=1;
+---------------+
| VR_SYSBR_CODE |
+---------------+
| $!\ |
+---------------+
1 row in set (0.00 sec)
也不是我想插入的内容请大家帮忙看下怎么回事如何查看这个语句的warning信息?
感谢
+---------+------+----------------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------------+
| Warning | 1265 | Data truncated for column 'VR_SYSBR_CODE' at row 1 |
+---------+------+----------------------------------------------------+
1 row in set (0.00 sec)
请教高手 问什么我在更新字段的时候 为什么会被truncated 呢
UPDATE TB_SYS_BRANCH SET VR_SYSBR_CODE="\$!\\''##" where ID_SYS_BRANCH=1;
如何才能避免这种报错呢
感谢
看看
恩 谢谢大家
`VR_SYSBR_CODE` varchar(3) NOT NULL,
的确是定义的长度太短了