I'm facing problem for
datetime fields while importing file using mysql command
load data local infile, but if I import the same file using
Table Data Import Wizard in MySQL Workbench it works perfectly. But this option is extremely slow. It's been more than 2 hrs only 10% data imported for only 12k data sample. As I found out that
load data local infile command is much faster, I'm going for it but stuck currently for
Sample data file content: (Last 2 fields are
updated_at fields which are having problem while importing)
740c02a0-54d9-11eb-b1aa-1312597791fc,RAMKKUMAR,[email protected],2018-16-05 21:05:00,2018-22-11 4:47:00
load data local infile 'C:/Newwamp64/bin/mysql/mysql5.7.26/bin/for.csv'
into table mytable.users
FIELDS OPTIONALLY ENCLOSED BY '"'
TERMINATED BY ','
LINES TERMINATED BY '
IGNORE 1 LINES
SET created_at = STR_TO_DATE(@created_at, '%Y-%d-%m %H:%i:%s');
All fileds are fine, except following two -
created_at -> NULL
updated_at -> 0000-00-00 00:00:00