如何更改mysql的默认路径(进入outfile)csv路径 [英] how to change the default path of mysql (into outfile) csv path

问题描述

我已安装 WAMP 并使用 mysql，但是使用 sql 查询(进入 outfile)并将 csv 文件存储在 wamp 文件夹/bin/mysql/data 文件夹下的默认位置.

i have installed WAMP and using mysql, however using sql query (into outfile) and storing the csv file on default location under wamp folder/bin/mysql/data folder.

我想覆盖这个位置并想将 csv 文件存储在任何位置.

I want to override this location and want to store the csv file on any location.

请告诉我该怎么做?

推荐答案

在窗口环境

select * into outfile 'c:/resources.txt' fields terminated by ',' optionally enclosed by '"' lines
terminated by '\n' from resources;

这篇关于如何更改mysql的默认路径(进入outfile)csv路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！