mysql更新数据提醒Truncated incorrect INTEGER value: 错误
在网上都找不到什么解决的方法。但是百度到一个个人博客后找到了解决的方法
报错的sql语句
update xx user set qq_password = 'xx_id' & photo = 'img' WHERE email = 'emailx'
然后这个是正确的执行语句
update xx user set qq_password = 'xx_id',photo = 'img' WHERE email = 'emailx'
把&改为,逗号就好了
后来看一老外使用存储过得也碰到这样的问题
Truncated incorrect INTEGER value: '1|Blondes'
存储过程函数
代码如下 | |
DELIMITER $$ DROP FUNCTION IF EXISTS `fnObjectTagGetObjectTags` $$ DECLARE _outObjectTags VARCHAR(2048); SET _outObjectTags = SELECT tagId, tagName RETURN _outObjectTags; END $$ DELIMITER ; |
使用过程
代码如下 | |
SELECT fnObjectTagGetObjectTags(3, album.albumId) |
Try an explicit cast of just the tagId www.111cn.net as a character before the concatenation, since you may be mixing binary and non-binary strings. Like
代码如下 | |
SELECT (CAST(GROUP_CONCAT(CONCAT(CAST(tagId AS CHAR), '|', tagName) separator '~') AS CHAR(10000) CHARACTER SET utf8)) |