I am trying to export a table from mysql to csv. This I have already achieved but in the csv file the fields of the exported columns do not appear.
The code I have used is the following:
select Nombre,Direccion INTO OUTFILE 'prueba.csv' FIELDS TERMINATED BY ';' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n';
How can I also export the names of the columns?