This article will discuss how to use sql query to upload data from the MySQL table to a CSV file.

SELECT * FROM name_table
INTO OUTFILE '/tmp/name_file.csv' FIELDS TERMINATED BY ';' ;

; - field separator (columns).

The file will be created on the local server where the MySQL database is installed.

That's all. Comment, subscribe. Bye everyone.