Import and export mysql table data with csv file

Importing csv file data into mysql table

LOAD DATA LOCAL INFILE '/importfile.csv'

INTO TABLE test_table

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

(field1, filed2, field3);

Exporting mysql table data into csv file

SELECT Name

INTO OUTFILE 'C:/Documents and Settings/Administrator/Desktop/picks/fq.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

ESCAPED BY '\\'

LINES TERMINATED BY '\n'

FROM users;