mysql数据导出自定义文件格式实例讲解

mysql数据导出自定义文件格式实例讲解

mysql> show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name | Value |
+--------------------------+-----------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | /var/lib/mysql-files/ |
+--------------------------+-----------------------+
3 rows in set (0.00 sec)


mysql> select * from config_p_infos INTO OUTFILE '/var/lib/mysql-files/config.txt';
Query OK, 30618 rows affected (0.05 sec)


mysql>