mysql - 如何在 Mysql WorkBench 中进行查询？

Question

我有一个包含插入和创建表的 .sql 脚本。我使用了“从脚本创建 EER 模型”

它创建了表格，但我看不到这些表格中的数据。

我转到查询菜单并尝试进行查询，但它给我一个无法连接到本地主机的错误。

我做的对吗？

Answer 1

根据 Create EER Model from SQL Script 记录:

Clicking this action item launches the Reverse Engineer SQL Script wizard. This is a multi-stage wizard that enables you to select the script you want to create your model from.

For further information, see Section 7.7.9.1, “Reverse Engineering Using a Create Script”.

点击该链接:

However, if you are working with a script that also contains DML statements you need not remove them; they will be ignored.

相反，您需要 Manage Data Import/Export Server Administration 下的选项(在主窗口的工作区部分)。