1292截断了不正确的DOUBLE值:'' [英] 1292 Truncated incorrect DOUBLE value: ''

问题描述

我正在mysql服务器上运行此查询，但收到警告.更新mdl_context设置深度= 2，路径= concat('/1/'，id)其中contextlevel = 50并且存在(从mdl_course c中选择"x"，其中c.id = mdl_context.instanceid和c.category = 0)和(mdl_context.path为null或mdl_context.depth = 0)；

I am running this query on mysql server but I received warning. update mdl_context set depth=2, path= concat('/1/',id) where contextlevel=50 and exists (select "x" from mdl_course c where c.id= mdl_context.instanceid and c.category=0) and (mdl_context.path is null or mdl_context.depth =0);

错误=>受影响的0行，64个警告:1292被错误的DOUBLE值截断了错误:"

errors=> 0 row(s) affected, 64 warning(s): 1292 Truncated incorrect DOUBLE value: ''

推荐答案

也许尝试替换

SELECT "x" 

使用

SELECT c.id

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