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';
Last active
May 22, 2020 10:35
-
-
Save ramingar/0b7c1f7dd3c0f54ed9826c168ea62f26 to your computer and use it in GitHub Desktop.
Exporta los resultados de una tabla a un archivo csv #mysql #import #csv #terminal
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment