gpt4 book ai didi

mysql - 错误代码 : 1292. 截断不正确的 DOUBLE 值

转载 作者:太空宇宙 更新时间:2023-11-03 11:29:05 25 4
gpt4 key购买 nike

我正在尝试通过查询插入数据:

insert into email (emailAddress, isPreferredEmail, customer_id, upload_id)
select cast(Email as char(100)) a,
TRUE,
(select id from customer c where c.dbvehregno=ChassisNo),
uploadid
from hyundaiindividualreport
where id in (select max(id)
from hyundaiindividualreport
where length(Email>=5)
and uploadid=900
group by ChassisNo);

但它正在抛出:

  Error Code: 1292. Truncated incorrect DOUBLE value

邮件表结构:

 Table: email
Columns:
email_Id bigint(20) AI PK,
emailAddress varchar(300) ,
isPreferredEmail bit(1) ,
updatedBy varchar(255) ,
customer_id bigint(20) ,
upload_id varchar(255)

最佳答案

这个表达式看起来不对:

length(Email >= 5)

我想你的意思是:

length(Email) >= 5

但是,它会在 MySQL 中生成特定错误似乎令人惊讶。

关于mysql - 错误代码 : 1292. 截断不正确的 DOUBLE 值,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/51477840/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com