|
1:配置文件 查找 secure_file_priv
如果没有需要mysqld下增加
2:导出csv语句实例
注意导出的路径要有读写权限
- select `manufacturer_id`,`name` from oc_manufacturer order by `name` asc INTO OUTFILE '/www/wwwroot/18shop/storage/cache/manufacturer.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '\n';
复制代码
|
|