MySQL Workbench 不显示查询结果
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/24739198/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Workbench not displaying query results
提问by jjmirks
When I query a table in MySQL Workbench, no results are shown, the result section is just blank, no grid or anything. However if I export the data, it is all there. Everything worked fine until a couple days ago.
当我在 MySQL Workbench 中查询表时，没有显示任何结果，结果部分只是空白，没有网格或任何东西。但是，如果我导出数据，它就在那里。一切正常，直到几天前。
Query settings:
查询设置：
- Max Length = 65536
- Continue on SQL Script Error = true
- "Safe Updates = true
- Leave autocommit mode enabled = true
- Progress status update interval = 500
- Default algorithm for ALTER table = Default
- Default lock for ALTER table = Default
- Limit Rows = true
- Limit Rows Count = 1000
- Max Field Value Length to Display = 256
- Treat BINARY/VARBINARY as nonbinary character string = false
- Confirm Data Changes = True
- 最大长度 = 65536
- 继续 SQL 脚本错误 = true
- “安全更新 = 真
- 启用自动提交模式 = true
- 进度状态更新间隔 = 500
- ALTER 表的默认算法 = 默认
- ALTER 表的默认锁 = 默认
- 限制行数 = true
- 限制行数 = 1000
- 要显示的最大字段值长度 = 256
- 将 BINARY/VARBINARY 视为非二进制字符串 = false
- 确认数据更改 = True
No queries work, an example would be SELECT * FROM database.address
没有查询工作，一个例子是 SELECT * FROM database.address
采纳答案by JuanN
I had the same problem after upgrading to Ubuntu 14.10. I found this linkwhich describes the steps to be followed in order to apply the patch. It takes a while since you have to start all over again: downloading, building, installing... but it worked for me! Sorry I'm not an expert and I can't provide further details.
升级到Ubuntu 14.10后我遇到了同样的问题。我找到了这个链接，它描述了应用补丁所要遵循的步骤。因为您必须重新开始，所以需要一段时间：下载、构建、安装……但它对我有用！抱歉，我不是专家，无法提供更多详细信息。
Here are the steps described in the link above:
以下是上面链接中描述的步骤：
If you want to patch and build mysql-workbench yourself, get the source from for 6.2.3. From the directory you downloaded it to, do:
wget 'http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-src.tar.gz'
tar xvf mysql-workbench-community-6.2.3-src.tar.gz && cd mysql-workbench-community-6.2.3-src
wget -O patch-glib.diff 'http://bugs.mysql.com/file.php?id=21874&bug_id=74147'
patch -p0 < patch-glib.diff
sudo apt-get build-dep mysql-workbench
sudo apt-get install libgdal-dev
cd build
cmake .. -DBUILD_CONFIG=mysql_release
make
sudo make install
如果您想自己修补和构建 mysql-workbench，请从 6.2.3 获取源代码。从您下载的目录中，执行以下操作：
wget ' http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.2.3-src.tar.gz'
tar xvf mysql-workbench-community-6.2.3-src.tar.gz && cd mysql-workbench-community-6.2.3-src
wget -O patch-glib.diff ' http://bugs.mysql.com/file.php?id=21874&bug_id=74147'
patch -p0 < patch-glib.diff
sudo apt-get build-dep mysql-workbench
sudo apt-get install libgdal-dev
光盘构建
cmake .. -DBUILD_CONFIG=mysql_release
制作
须藤制作安装
Hope this can be helpful.
希望这会有所帮助。
回答by Thaumant
This is a known bug: link. Upcoming release 6.2.2 fixes this for OS X (Unfortunately, Linux version is still broken).
这是一个已知错误：链接。即将发布的 6.2.2 版本为 OS X 修复了这个问题（不幸的是，Linux 版本仍然损坏）。
At least on my computer it's not dissapeared, just folded, and it's edge is almost merged with the edge of 'Action Output' block. When you move your mouse to that edge, the cursor starts looking like a dash with two arrows. Slowly move it couple of pixels higher until you catch the small 1px area where the cursor changes to a dash with a single arrow. Then catch it and pull : )
至少在我的电脑上它没有消失，只是折叠起来，它的边缘几乎与“动作输出”块的边缘合并。当您将鼠标移到该边缘时，光标开始看起来像带有两个箭头的破折号。慢慢将其向上移动几个像素，直到您看到光标变为带有单个箭头的破折号的 1px 小区域。然后抓住它并拉:)
I've made a couple of photos to illustrate this.
我拍了几张照片来说明这一点。
回答by rob23
New to MySql myself and found this is happening on Windows as well. Goto Query > Explain Current Statement > click on the Results Grid icon on the far right of the Visual Explain window that shows by default. You may have to toggle through the up down arrow icons to see it.
我自己是 MySql 的新手，发现这也在 Windows 上发生。转到查询 > 解释当前语句 > 单击默认显示的 Visual Explain 窗口最右侧的结果网格图标。您可能需要在上下箭头图标之间切换才能看到它。
回答by Fred Perrin
The problem, as it is described, corresponds exactly to the bug MySQL Bugs: #74147: empty grid result, incompatibiliity with libglib_2.42
正如所描述的，该问题完全对应于错误MySQL 错误：#74147：空网格结果，与 libglib_2.42 不兼容
The good news is it's almost closed.
好消息是它几乎关闭了。
A patch is available since today.
补丁从今天开始可用。
EDIT : In Debian Jessie (testing), the problem is solved with the package mysql-workbench 6.2.3+dfsg-6 available since today.
编辑：在 Debian Jessie（测试）中，问题已通过 mysql-workbench 6.2.3+dfsg-6 软件包解决。
回答by Satyam Naolekar
It was really frustrating as it was still happening in the workbench version 6.3.10 (for mac) available in the mysql official site (here). I got it resolved by first collapsing the bottom panel (check the top right in the attached image (termed as collapse button)) and then pulling up the empty region from the bottom. Now if I again click on collapse button this time result grid is visible along with the action grid.
这真的很令人沮丧，因为它仍然发生在 mysql 官方网站（此处）提供的工作台版本 6.3.10（适用于 mac）中。我通过首先折叠底部面板（检查附加图像中的右上角（称为折叠按钮））然后从底部拉起空白区域来解决它。现在，如果我再次单击折叠按钮，这次结果网格与操作网格一起可见。
回答by zmonteca
This was still happening to me on version 6.3.9 on OSX. I downloaded 6.1.7 again to actually see the result grid again.
在 OSX 上的 6.3.9 版中，这仍然发生在我身上。我再次下载了 6.1.7 以再次实际查看结果网格。
What a pain in the butt!
屁股好痛啊！
回答by Sudarshan Shubakar
Update manually from mysql website
从mysql 网站手动更新
Here's a solution for Ubuntu 15.04 users running Mysql Workbench 6.2.3.
这是运行 Mysql Workbench 6.2.3 的 Ubuntu 15.04 用户的解决方案。
I was able to resolve the issue of missing results in the Mysql workbench by just upgrading mysql-workbench to version 6.3.3 from http://dev.mysql.com/downloads/workbench/. You will need to download the one marked for Ubuntu 14.10. An install via Ubuntu software center resolved the issue. Hope this helps.
只需将 mysql-workbench 从http://dev.mysql.com/downloads/workbench/升级到 6.3.3 版，我就能够解决 Mysql 工作台中缺少结果的问题。您需要下载标记为 Ubuntu 14.10 的那个。通过 Ubuntu 软件中心安装解决了这个问题。希望这可以帮助。
回答by oOEric
I'm using MySqlWorkbench 6.3.9 on macOS and has this problem. I removed the app and installed 6.3.10 which solves the problem.
我在 macOS 上使用 MySqlWorkbench 6.3.9 并且有这个问题。我删除了应用程序并安装了解决问题的 6.3.10。
回答by to_masz
MySQL Workbench 6.3.4 fixes this issue. Custom builds are not needed anymore.
MySQL Workbench 6.3.4 修复了这个问题。不再需要自定义构建。
回答by karmarro
The result set wasn't showing for me either. I was able to make it appear by hiding the output area and running a simple select statement. Then I "show"ed the output area again and had what I was looking for -- both the result set and the output area
结果集也没有显示给我。我可以通过隐藏输出区域并运行一个简单的 select 语句来让它出现。然后我再次“显示”输出区域并得到了我想要的——结果集和输出区域
