mysql export csv

SELECT name, url FROM links INTO outfile '/tmp/links.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';