Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
LOAD DATA LOCAL INFILE '/tmp/example.csv'
-> INTO TABLE example
-> FIELDS TERMINATED BY ','
-> LINES TERMINATED BY '\n'
-> IGNORE 1 LINES
-> (id, Column3,Column4, @Column5)
-> set
-> Column5 = str_to_date(@Column5, '%m/%d/%Y');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment