mysql select into outfile

 vim /etc/my.cnf

[mysqld]

#开启outfile
secure_file_priv='/server/mysql_data'

show variables like 'secure_file_priv';

SELECT id FROM xiaodai.`user_info` WHERE DEL_FLAG=0 into outfile "/server/mysql_data/id.txt";

 

 

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement