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?

John Woo · Accepted Answer · 2013-03-14 05:59:18Z

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, 2013 at 5:59

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

Comments

divyabharathi · Accepted Answer · 2013-03-14 06:13:31Z

1

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

answered Mar 14, 2013 at 6:13

divyabharathi

2,24718 silver badges12 bronze badges