mysql [Err] 1292

最新推荐文章于 2023-12-05 19:11:54 发布

无知懵懂

最新推荐文章于 2023-12-05 19:11:54 发布

阅读量2.5k

点赞数 1

分类专栏： mysql日常err 文章标签： mysql

本文链接：https://blog.csdn.net/qq_23082219/article/details/72638316

版权

mysql日常err 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

在执行多表update的时候出现了[Err] 1292 - Truncated incorrect DOUBLE value: 'c90125dab2fa4a96a83029b08dafb9b7'

sql如下

UPDATE circle
LEFT JOIN circle_member ON circle.id = circle_member.circle_id
AND circle_member.is_delete = 0
LEFT JOIN circle_member_apply_add ON circle.id = circle_member_apply_add.circle_id
AND circle_member_apply_add.is_delete = 0
LEFT JOIN topic ON circle.id = topic.circle_id
AND topic.is_delete = 0
LEFT JOIN topic_file ON topic_file.topic_id = topic.id
AND topic_file.is_delete = 0
LEFT JOIN topic_comment ON topic_comment.topic_id = topic.id
AND topic_comment.is_delete = 0
LEFT JOIN topic_comment_detail_reply ON topic_comment_detail_reply.topic_comment_id = topic_comment.id
AND topic_comment_detail_reply.is_delete = 0
LEFT JOIN activity ON activity.circle_id = circle.id
AND activity.is_delete = 0
LEFT JOIN activity_comment ON activity_comment.activity_id = activity.id
AND activity_comment.is_delete = 0
LEFT JOIN activity_comment_detail_reply ON activity_comment_detail_reply.activity_comment_id = activity_comment.id
AND activity_comment_detail_reply.is_delete = 0
LEFT JOIN activity_join_info ON activity_join_info.account_id = activity.id
AND activity_join_info.is_delete = 0
SET circle.is_delete = 1,
circle_member.is_delete = 1,
circle_member_apply_add.is_delete = 1,
topic.is_delete = 1,
topic_file.is_delete = 1,
topic_comment.is_delete = 1,
topic_comment_detail_reply.is_delete = 1,
activity_comment.is_delete = 1,
activity_comment_detail_reply.is_delete = 1,
activity.is_delete = 1,
activity_join_info.is_delete = 1
WHERE
circle.id = '23'