kymbrik
4/28/2018 - 9:01 AM
How to output MySQL query results in CSV format?
https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option https://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format
SELECT order_id,product_name,qty
FROM orders
WHERE foo = 'bar'
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
Если пикать другую директорию, то может вылезти ошибка Error Code: 1290.
Директория должна соответствовать SHOW VARIABLES LIKE "secure_file_priv";