windows MySQL 5.7 导出表方法记录

首先修改MySQL配置

找到mysql安装目录下的 my.ini 文件，将

secure-file-priv = "C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"

追加到my.ini 的末尾处，重启MySQL

执行导出命令

SELECT * FROM user
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/user06.csv'
    FIELDS TERMINATED BY ','
    ENCLOSED BY ''
    LINES TERMINATED BY '\n'