select * from table_name into outfile 'path.csv' FIELDS TERMINATED BY ',' ;