Top "Into-outfile" questions

MySQL's `SELECT ... INTO OUTFILE` command lets you quickly dump the results of a MySQL query into a file on the MySQL server.

exporting a table in MySQL with columns that have newline characters

I am pretty inexperienced in SQL, so there should be a simple solution to my problem: I am selecting a …

mysql sql into-outfile
how can i save the file after SELECT ... INTO OUTFILE 'result.csv'

i use this query to dump table into csv file : $sql = "SELECT * INTO OUTFILE 'result.csv' FIELDS TERMINATED BY ';…

php mysql sql into-outfile
Show Databases/Tables INTO OUTFILE

Is there a way of getting the output of a SHOW DATABASES or SHOW TABLES command to output to a …

mysql into-outfile
MySQL query to print output as CSV to standard output

I want to do the following mysql -uuser -ppass -h remote.host.tld database < script.sql where script.sql …

mysql sql into-outfile