Monday, 18 March 2013

Export MySQL Table to a CSV File

SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv' 
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
 

No comments:

Windows Problem Steps Recorder

Windows Problem Steps Recorder (PSR) is a built-in Windows utility that automatically captures screenshots and annotates steps to help troub...