如何一起运行mysql Workbench的2个选项? [英] How do I run 2 options of mysql Workbench together?
问题描述
我正在尝试编写一个命令行脚本,
I am trying to write a command-line script which will
- 打开工作台
- 连接到指定的数据库
- 打开一个sql文件
- 运行
- 将结果导出到文本文件
I made use of workbench's guide for command-line guide from (https://dev.mysql.com/doc/workbench/en/wb-command-line-options.html) up to the point of opening the app and connecting to the database. However, I can't combine the options. The options I write after "connect to database" are not read or run properly.
我的问题是如何将它们组合/管道化.
My question is how to combine/pipe them together.
以下命令运行该应用程序并连接到数据库:
The following command runs the app and connects to the database:
"C:\..\MySQLWorkbench.exe" --query testdb
当我添加-脚本C:\ .. \ 23.10.20.sql
或-打开C:\ .. \ 23.10.20.sql
时,它们没有效果.我只使用空窗口将应用程序连接到数据库.我将它们结合起来:
When I add --script C:\..\23.10.20.sql
or --open C:\..\23.10.20.sql
they have no effect. I only get the app connected to the database with an empty window.
I combine them like:
"C:\..\MySQLWorkbench.exe" --query testdb --script C:\..\23.10.20.sql
将它们组合在一起是正确的方法吗?
Is that the right way to combine them?
通过一起尝试其他两个选项,我确认这不是正确的方法.对于如何一个接一个地运行两个选项,我仍然需要一个答案.
By trying two other options together, I confirmed that this is not the right way. I still need an answer for how to run 2 options one after the other.
我使用的工作台指南中的选项是:
The options from the workbench's guide I use are:
--query [connection|connection_string]:
Connection: Open a named connection.
--model modelfile: open the given EER model file.
--script script: Open the given SQL file in a connection, typically used with the --query parameter.
--run code: Execute the given code using the default language for GRT shell.
--open file: Open the given file at startup. Deprecated, so instead use specific types such as --script or --model.
注意:本指南中有一条注释,表示Windows应使用一个破折号(-),而不是两个破折号(-).尽管我使用的是Windows,但对我而言并非如此.仅当我使用两个破折号时才运行这些选项.短划线,什么也没有发生.
Note: There is a note in this guide saying one dash (-) should be used for Windows instead of two (--). Although I am using Windows, that is not the case for me. The options are only run when I use two dashes. With one dash, nothing happens.
推荐答案
您不能使用WB导出结果,只能打开特定的连接并运行查询或运行python脚本.从原则上讲,可以使用Python导出数据,但这需要花费很多精力.
You cannot use WB to export a result, only to open a specific connection and run a query or to run a python script. In principle it would be possible to use Python to export the data, but this is quite a lot of work for a small effect.
相反,我建议完全不要使用WB,而是直接在脚本中使用MySQL.GUI不太适合进行终端工作.
Instead I recommend not to use WB at all and instead work directly with MySQL in your script. A GUI is not well suited to do terminal work.
这篇关于如何一起运行mysql Workbench的2个选项?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!