将CSV日期更改导入到0000-00-00 [英] Import csv date changes to 0000-00-00
本文介绍了将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屋!
查看全文