How do I export data in CSV format

To export data from a MySQL database into CSV format, you can use the following SQL query. This method uses the `SELECT ... INTO OUTFILE` statement to write the output directly to a CSV file.

Example


        SELECT * FROM your_table_name 
        INTO OUTFILE '/path/to/your/output.csv' 
        FIELDS TERMINATED BY ',' 
        ENCLOSED BY '"' 
        LINES TERMINATED BY '\n';