大米CMS官网论坛,大米站长联盟,大米站长之家,大米开发者社区
标题:
mysql导出CSV
[打印本页]
作者:
追影
时间:
2023-5-18 10:46
标题:
mysql导出CSV
1:配置文件 查找 secure_file_priv
如果没有需要mysqld下增加
secure_file_priv = ''
复制代码
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';
复制代码
欢迎光临 大米CMS官网论坛,大米站长联盟,大米站长之家,大米开发者社区 (https://www.damicms.com/bbs/)
Powered by Discuz! X3.1