MySQL Export to CSV

Export data from MySQL into a CSV file,Its simple by using this query. SELECT * INTO OUTFILE '/tmp/name.csv'FIELDS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"'ESCAPED BY '\\'LINES TERMINATED BY '\n'FROM [tablenam...

 
java4practices © 2013 | Designed by Ganesh Rengarajan