java - mysql - 选择查询输出文件 - 文件保存在哪里
使用jdbc从java连接到mysql数据库。 声明执行查询
String query =
"SELECT *"+
"FROM tt2"+
"INTO OUTFILE 'DataFormatted.csv'"+
"FIELDS TERMINATED BY ','"+
"ENCLOSED BY '\"'" +
"LINES TERMINATED BY '\n'";
使用executeQuery(query)
的查询。如何更改上面的代码以将DataFormatted.csv保存到C盘根目录
connecting to a mysql database from java using jdbc.
declaring a query
String query =
"SELECT *"+
"FROM tt2"+
"INTO OUTFILE 'DataFormatted.csv'"+
"FIELDS TERMINATED BY ','"+
"ENCLOSED BY '\"'" +
"LINES TERMINATED BY '\n'";
executing query using executQuery(query).
how to change above code to save DataFormatted.csv into c drive root directory
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
在 MySQL 服务器的当前工作目录中。到底是哪一种取决于MySQL服务器是如何执行和配置的。最好的方法是将 CSV 文件的位置更改为固定位置。
只需将
'DataFormatted.csv'更改为'C:/DataFormatted.csv'.请注意，如果您还想通过 Java 访问 CSV 文件，Java 代码和 MySQL 服务器应该在物理上运行在同一台计算机上。如果它们在物理上不同的计算机上运行，那么您可能会寻找其他方法来访问 CSV 文件，例如通过 FTP 传输生成的 CSV 文件。
In the current working directory of the MySQL server. Which one it is depends on how the MySQL server is executed and configured. Best is to change the location of the CSV file to a fixed location.
Just change
'DataFormatted.csv'by'C:/DataFormatted.csv'.Be aware that both Java code and the MySQL server should run at physically the same machine if you want to access the CSV file by Java as well. If they runs at physically different machines, then you'll probably look for other ways to access the CSV file, e.g. FTP'ing the generated CSV file.
假设您的 SQL 查询是正确的（您的示例在换行符处缺少空格），OUTFILE 会将文件保存在服务器上。
如果未给出路径，它将进入数据目录中具有用户名的子目录中。
它类似于
test用户的C:\Program Files\MySQLServer\data\test。要了解数据目录是什么，请使用
show Variables where variable_name = 'datadir'查询。要更改 OUTFILE 的位置，只需使用完整路径，如
BalusC所建议。Assuming your SQL query is correct (your example is missing spaces at line break), the OUTFILE saves the File on the server.
If no path is given, it will go in the Data Directory, in a subdirectory with the user's name.
It's something like the
C:\Program Files\MySQLServer\data\testfor thetestuser.To find out what the data directory is, use the
show variables where variable_name = 'datadir'query.To change the location of OUTFILE just use the complete path, as suggested by
BalusC.将数据转储到 MySQL 服务器 计算机上的文件中。如果要在Java客户端上创建本地文件，则需要自己创建。
dumps the data into a file on the MySQL server machine. If you want to create a local file on the Java client, you will need to create it yourself.