Save MySQL results into a text or CSV file

MySQL

 

The world's second most used open-source database. Skyvia requires the server to be available from Internet. Skyvia supports MySQL, Percona, and MariaDB servers.

Easy mechanism for writing the results of a select statement into a text file on the server

Query Text

SELECT OrderID, OrderDate, Freight
FROM orders
INTO OUTFILE '/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
  

Open Query