import date from csv file into mysql using bash

Question

I have this pattern 27-FEB-17 in a csv file. how can i keep this format on mysql using DATE and not CHAR?

!/bin/bash

mysql --user= --password= --local_infile=1 models -e "LOAD DATA LOCAL INFILE '/home/27022017.csv' INTO TABLE test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ignore 1 lines"

thank's

Martin Buezas · Accepted Answer · 2017-03-08 20:34:21Z

0

MySQL DATE type format is YYYY-MM-DD. You can't keep that formatting under the DATE type.

If your goal is not to iterate and transform the dates formatting you could look into triggers to post-process the string values into a proper DATE

answered Mar 8, 2017 at 20:34

Martin Buezas

4043 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

import date from csv file into mysql using bash

!/bin/bash

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

!/bin/bash

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related