将CSV日期更改导入到0000-00-00 [英] Import csv date changes to 0000-00-00

查看:78
本文介绍了将CSV日期更改导入到0000-00-00的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

LOAD DATA INFILE 'filename.csv' INTO TABLE table_name 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\n' IGNORE 1 LINES 
(Date,col2,col3,col4,col5,col6,col7,@dummy_variable)
Set dummy_variable = 0

可以正常加载,但日期格式显示为0000-00-00

Loads fine but date format shows reads 0000-00-00

csv中的日期采用dd/mm/yyyy样式,无法在csv文件中更改.

Date in csv is in the style dd/mm/yyyy, can't be changed in csv file.

推荐答案

您需要使用str_to_date

类似下面的方法应该起作用.

Something like below should work.

LOAD DATA INFILE 'filename.csv' INTO TABLE table_name 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\n' IGNORE 1 LINES 
(@myDate,col2,col3,col4,col5,col6,col7,@dummy_variable)
Set dummy_variable = 0, Date = str_to_date(@myDate,'%d/%m/%Y')

这篇关于将CSV日期更改导入到0000-00-00的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆