无效的日期时间格式:1292 截断了不正确的 DOUBLE 值 [英] Invalid datetime format: 1292 Truncated incorrect DOUBLE value

问题描述

我触发了这个 sql 查询，然后返回这个错误.

I am fire this sql query and then return this error.

我的错误:

1292 截断了不正确的 DOUBLE 值:'1,2,3,4,5,6,7,122,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,157,153,154,155,156'正在执行的 SQL 是:

1292 Truncated incorrect DOUBLE value: '1,2,3,4,5,6,7,122,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,157,153,154,155,156' The SQL being executed was:

我的查询:

DELETE FROM groups_module_actions 
WHERE module_action_id NOT IN('1,2,3,4,5,6,7,122,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,26,157,153,154,155,156') AND group_id='1'

推荐答案

跳过 NOT IN () 中的引号，它期望的数据类型 integer 不是 字符串.

Skip the quotes in the NOT IN (), its expecting datatype integer not a string.

DELETE FROM groups_module_actions WHERE module_action_id 
NOT IN(1,2,3,4,5,6,7,122,8,9,10,11,12,13,14,15,16,17,18,19,20,
21,22,23,24,25,26,157,153,154,155,156) 
AND group_id=1

这篇关于无效的日期时间格式:1292 截断了不正确的 DOUBLE 值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！