如何从远程连接到用户的本地机器编写mysql csv文件 [英] how to write mysql csv file from remote connection to user's local machine

问题描述

你好

i希望从mysql语句中写入CSV文件

Hello
i want to write CSV file from mysql statment

SELECT * FROM dim_warehouses INTO OUTFILE 'D:/LocalFileTest.csv'

但文件已写入服务器驱动器而非本地机器



请将csv文件保存在用户机器上，而不是远程连接上



非常感谢

but the file has been written into server drive not local machine

please i want to save the csv file on user's machine not on Remote Connection

Thanks alot

推荐答案

服务器必须能够访问您想要保存的位置。因此，您可以将驱动器从服务器映射到客户端，或者您需要稍后手动复制它，或者可能需要脚本来复制它。

The server has to have access to wherever you want to save it. So, you could map a drive from the server to the client or you'll need to manually copy it later or perhaps get a script to copy it.

这篇关于如何从远程连接到用户的本地机器编写mysql csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！