MySQL Export query results

SELECT * from my_table into outfile '/tmp/abc.xls ';

Then it is ftp to get the files back to the local. My program is automatically placed in C + +

In addition, there is a way to export, compared to the above, this can be directly overwrite the existing files.

Ways to use outfile

Mysql> Select 1 into outfile '/tmp/t1.txt ';

Query OK, 1 row Affected (0.00 sec)

Mysql> Select 1 into outfile '/tmp/t1.txt ';

ERROR 1086 (HY000): File '/tmp/t1.txt ' already exists

Can only be exported to the TMP directory, other directories will be error

Another way:

Script Export:

#!/bin/bash

Cat << Endf | Mysql-u root-proot > Tmes.txt

SELECT * from test. 1_account;

Endf

------------------------------------

Note Add a database. Table name

MySQL Export query results