Import CSV in MySql Workbench

This is a quick tip on how to import a csv with data into one of your tables.

1º Open MySql Workbench

2º run the following query

On linux:

load data local infile ‘/path/to/your/file.csv’ into table dbName.tableName fields terminated by ‘,’ enclosed by ‘”‘ lines terminated by ‘\n’;

On Windows

load data local infile ‘c:\\path\\to\\your\\file.csv’ into table dbName.tableName fields terminated by ‘,’ enclosed by ‘”‘ lines terminated by ‘\n’;

 

Digg thisBuffer this pageShare on FacebookShare on Google+Share on LinkedInPin on PinterestShare on RedditShare on StumbleUponShare on TumblrTweet about this on Twitter