方法1
SELECT orderid INTO
OUTFILE 'd:/orderid.txt'
LINES TERMINATED BY '\r\n'
FROM `t_aaa_order`?
报错The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
参考文章
方法2
sqlyog(mysql的客户端)>选中表,右键>导出>导出表数据作为