Importing CSV to mysql |

Mar 17

Importing CSV to mysql

Category: mysql

Something pretty straight forward..

if i have a csv as shown below

to import to mysql
1) go to the directory of the csv file. e.g. words.csv

“airy”
“amused”
“animated”
“beatific”
“blissful”
“blithe”
“bright”
“brisk”
“buoyant”
“cheerful”

3) go into mysql admin

mysql -u root -p

4) run command

>LOAD DATA INFILE “./words.csv” INTO TABLE happy FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “”"” TERMINATED BY ‘\n’;

the words.csv is saved under /var/lib/mysql.

5) and its done.

mysql> select * from happy;

+—————-+
| nameÂ Â Â Â Â Â Â Â Â Â |
+—————-+
| airyÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
| amusedÂ Â Â Â Â Â Â |
| animatedÂ Â Â Â Â |
| beatificÂ Â Â Â Â Â Â Â |
| blissfulÂ Â Â Â Â Â Â Â Â Â |
| blitheÂ Â Â Â Â Â Â Â Â Â Â Â |
| brightÂ Â Â Â Â Â Â Â Â Â Â |