show global variables like '%secure_file_priv%'; 查看目录在哪
然后写sql:
SELECT 1,2 into outfile '/var/lib/mysql-files/tmp2.csv' FIELDS TERMINATED BY ',';
show global variables like '%secure_file_priv%'; 查看目录在哪
然后写sql:
SELECT 1,2 into outfile '/var/lib/mysql-files/tmp2.csv' FIELDS TERMINATED BY ',';