mysqlworkbench如何导出查询结果

步骤一：找到本地文件导出权限位置

show variables like '%secure%'; ##用于查看本地文件导入权限是否开启
set global local_infile =1; ##打开权限
show global variables like '%secure_file_priv%';##找到权限的目录
步骤二：导出查询结果

查询语句
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/qd1结果.csv' ##导出权限位置目录
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';