Export To CSV

[visualAd]

In mysql you can do it with a query:

SELECT * INTO OUTFILE 'c:\path\to\csv.csv'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  FROM table_name;