A collection of 3 posts

Export MySQL results to outfile/CSV

mysql outfile csv export

To export MySQL results to an outfile or CSV file: SELECT column_name FROM table_name INTO OUTFILE '/var/lib/mysql-files/export.csv'; If you receive the following error: The MySQL server is running with the --secure-file-priv option so it cannot execute this

You've successfully subscribed to Base 64!
Could not sign up! Invalid sign up link.