how to Export data from csv file into mysql database?

Question

how to Export data from csv file into mysql database? is there any Query or some othr way avial?

http://stackoverflow.com/questions/7442285/please-help-me-to-load-csv-to-mysql — , Mar 14 '13 at 06:40

score 2 · Accepted Answer · answered Mar 14 '13 at 05:59

2

I think you mean IMPORT., here's how:

load data local infile 'yourCSVfilepath.csv' into table tableNameHERE
fields terminated by ','
optionally enclosed by '"'
lines terminated by '\r\n'

answered Mar 14 '13 at 05:59

John Woo

score 1 · Answer 2 · answered Mar 14 '13 at 06:13

To Export data to csv from Mysql use this

SELECT *
INTO OUTFILE '/tmp/tablename.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM tablename

To import csv to Mysql use this

LOAD DATA INFILE 'c:/tablename.csv' INTO TABLE tablename

2 Answers2