Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: select into outfile文件路径是否可以设置在客户端
Can the file path for SELECT INTO OUTFILE
be set on the client side?
Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: select into outfile文件路径是否可以设置在客户端
Can the file path for SELECT INTO OUTFILE
be set on the client side?
It can only be exported to the corresponding TiDB server machine.
No, and it’s more appropriate to use dumpling to export with TiDB.
select into outfile
cannot directly export data to the local client machine; it can only be exported to the server where the database is located.mysql --defaults-file=tidb-xx.cnf -Nse"select xxx" > xxx.txt
to indirectly achieve local export.In MySQL, executing select into outfile can export data to the local machine, but TiDB behaves differently in this scenario. ----> MySQL also doesn’t allow this; it can only export to the machine where MySQL is located, not to the machine where the client is located, right?
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.