首页 文章

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

提问于
浏览
0

我试图通过查询插入数据:

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);

但它正在抛出:

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


电子邮件表结构:

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)

1 回答

  • 2

    这个表达式看起来不正确:

    length(Email >= 5)
    

    我想你的意思是:

    length(Email) >= 5
    

    但是,它会在MySQL中产生特定错误,这似乎令人惊讶 .

相关问题