错误代码: 1292 Truncated incorrect DOUBLE value: '空'

5G架构师 发布于 2016/10/14 10:14
阅读 1K+
收藏 0
INSERT INTO emp_target(mail_name, tag_id, tag_value,units,compute_date )
SELECT a.`employee_account`,"0416" ,SUM(a.`end_time`)  , "1" ,'2016-09' 
FROM index_search_data a
 WHERE a.`start_time` >= '2016-09-01' AND '2016-09-31' >= a.`start_time` 
 GROUP BY a.`employee_name`;




加载中
返回顶部
顶部