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.

Include headers when using SELECT INTO OUTFILE?

Is it possible to include the headers somehow when using the MySQL INTO OUTFILE?

mysql into-outfile
MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777

Any ideas? SELECT * INTO OUTFILE '/home/myacnt/docs/mysqlCSVtest.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '*…

mysql mysql-error-1045 into-outfile
MySQL export into outfile : CSV escaping chars

I've a database table of timesheets with some common feilds. id, client_id, project_id, task_id, description, time, date …

mysql sql excel into-outfile
How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?

I am trying to dump the contents of a table to a csv file using a MySQL SELECT INTO OUTFILE …

mysql sql into-outfile
MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be …

mysql sql mariadb into-outfile
MySQL INTO OUTFILE override existing file?

I've written a big sql script that creates a CSV file. I want to call a cronjob every night to …

php mysql sql into-outfile
MySQL SELECT INTO OUTFILE Export options

Does anyone know where can I find the documentation for all the export options of the SELECT ... OUTFILE statement of …

mysql into-outfile
SELECT INTO OUTFILE can't write to file

I'm trying to do a SELECT INTO OUTFILE and I'm getting the following error: General error: 1 Can't create/write to …

mysql sql linux into-outfile
Syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in PHP

mysql_connect("localhost","root",""); mysql_select_db("hitnrunf_db"); $result=mysql_query("select * from jos_users INTO OUTFILE 'users.csv' …

php mysql sql into-outfile
Output MySQL source results to log file

I am trying to execute foo.sql using the source command in MySQL. When I type the command, the file …

mysql sql into-outfile