You have an external application that requires an input file with comma-separated values.
How can you produce such a file containing the contents of the countryLanguage table using MySQL’s select?
A.
SELECT * FROM CountryLanguage
INTO OUTFILE ‘/tmp/CountryLanguage.csv’ WITH SEPARATOR ‘,’
B.
SELECT * FROM CountryLanguage
INTO OUTFILE ‘/tmp/CountryLanguage.csv’ FIELDS TERMINATED BY ‘,’
C.
SELECT * FROM CountryLanguage
INTO OUTFILE ‘/tmp/CountryLanguage.csv’ AS CSV
D.
There is no support for exporting comma-separated data.
Explanation:
Fields (values) seperated by commas