MySQL Workbench不显示查询结果 [英] MySQL Workbench not displaying query results

问题描述

当我在MySQL Workbench中查询表时，没有显示任何结果，结果部分只是空白，没有网格或其他任何内容.但是，如果我导出数据，则数据就在那里.直到几天前，一切正常.

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.

查询设置:

• 最大长度= 65536
• 继续执行SQL脚本错误= true
• 安全更新= true
• 保持启用自动提交模式= true
• 进度状态更新间隔= 500
• ALTER表的默认算法=默认
• ALTER表的默认锁定=默认
• 限制行= true
• 限制行数= 1000
• 要显示的最大字段值长度= 256
• 将BINARY/VARBINARY视为非二进制字符串= false
• 确认数据更改= True

• 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

没有查询有效，例如SELECT * FROM database.address

推荐答案

升级到 Ubuntu 14.10 后，我遇到了同样的问题.我发现了此链接，其中描述了要遵循的步骤为了应用补丁.因为您必须重新开始，所以需要一段时间:下载，构建，安装...但是它对我有用！抱歉，我不是专家，我无法提供更多详细信息.

I had the same problem after upgrading to Ubuntu 14.10. I found this link which 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.

以下是上面链接中描述的步骤:

Here are the steps described in the link above:

如果您想自己打补丁并构建mysql-workbench，请从6.2.3获取源代码.从下载到的目录中，执行以下操作:

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

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 '

wget -O patch-glib.diff 'http://bugs.mysql.com/file.php?id=21874&bug_id=74147'

补丁-p0< patch-glib.diff

patch -p0 < patch-glib.diff

sudo apt-get build-dep mysql-workbench

sudo apt-get build-dep mysql-workbench

sudo apt-get install libgdal-dev

sudo apt-get install libgdal-dev

cd版本

cmake .. -DBUILD_CONFIG = mysql_release

cmake .. -DBUILD_CONFIG=mysql_release

制作

sudo make install

sudo make install

希望这会有所帮助.

这篇关于MySQL Workbench不显示查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！