我正在触发此sql查询,然后返回此错误。
我的错误:
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 是:
我的查询:
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
不是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