MYSQL报错The MySQL server is running with the --secure-file-priv option so it cannot execute this sta
show variables like ‘%secure%’;查看 secure-file-priv 当前的值是什么
![image-20220714215314453](https://i-blog.csdnimg.cn/blog_migrate/0f85db01ec382ff6f4142523e2352c76.png)
默认是NULL就代表禁止导出,所以需要设置一下
mysql安装路径下的my.ini文件,设置一下路径:
![image-20220714215512160](https://i-blog.csdnimg.cn/blog_migrate/c0270ecd78dd08c1f6363d2e0f87e4f7.png)
重新启动mysql服务
net stop mysql
net start mysql
## 导入导出文件
load data infile 'd:/data.txt' into table s(course,stu_name,score);
select * from stu_score into outfile 'd:/a.txt';