SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'; Monday, 18 March 2013
Export MySQL Table to a CSV File
Subscribe to:
Posts (Atom)
SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';