entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/db6a47fb51b98e224d0859d0823ef5ed.png|imageAlt|1|https://ask.qcloudimg.com/http-save/actteam/da4297a99adc5214a89cf2d76e67a004.png|blocks|key|3vce0|text|首先从主屏幕打开到服务器的连接(SQL+IDE)。然后使用架构树中的上下文菜单来运行一个查询，该查询只是从所选表中选择行。附加的限制是避免意外读取太多行。此限制可在首选项对话框中关闭(或调整)。|unstyled|depth|inlineStyleRanges|entityRanges|b0vj5|?|atomic|offset|length|d9pkr|但是，这种快速选择行的方法并不十分灵活。通常，您会在编辑器中运行带有附加条件的查询(文件/新建查询选项卡)，如排序顺序：|7anaq|dj731|fcklv|​^0|0|0|1|0|0|0|0|1|1|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]|A|$2|3|4|5|6|$7|B|9|-4]]]|C|@$D|E|F|G|2|H|I|W|J|@]|K|@]|6|$]]|$D|L|F|M|2|N|I|X|J|@]|K|@$O|Y|P|Z|D|10]]|6|$]]|$D|Q|F|R|2|H|I|11|J|@]|K|@]|6|$]]|$D|S|F|M|2|N|I|12|J|@]|K|@$O|13|P|14|D|15]]|6|$]]|$D|T|F|-4|2|H|I|16|J|@]|K|@]|6|$]]|$D|U|F|V|2|H|I|17|J|@]|K|@]|6|$]]]]

Open a connection to your server first (SQL IDE) from the home screen. Then use the context menu in the schema tree to run a query that simply selects rows from the selected table. The LIMIT attached to that is to avoid reading too many rows by accident. This limit can be switched off (or adjusted) in the preferences dialog.

<img src="https://i.stack.imgur.com/LGATj.png" alt="enter image description here">

This quick way to select rows is however not very flexible. Normally you would run a query (File / New Query Tab) in the editor with additional conditions, like a sort order:

<img src="https://i.stack.imgur.com/vtog8.png" alt="enter image description here">

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/285b15ea9c86584f95c39cfa6a34498f.png|imageAlt|blocks|key|fn5t1|text|选择数据库，选择表，点击图标，如图所示。|unstyled|depth|inlineStyleRanges|entityRanges|2ki12|?|atomic|offset|length|2bi0l|6f2q3|​^0|0|0|1|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|R|H|@]|I|@]|6|$]]|$B|J|D|K|2|L|G|S|H|@]|I|@$M|T|N|U|B|V]]|6|$]]|$B|O|D|-4|2|F|G|W|H|@]|I|@]|6|$]]|$B|P|D|Q|2|F|G|X|H|@]|I|@]|6|$]]]]

Select Database , select table and click icon as shown in picture.<a href="https://i.stack.imgur.com/xW3zL.png" rel="noreferrer"><img src="https://i.stack.imgur.com/xW3zL.png" alt="enter image description here"></a>

entityMap|blocks|key|fv6sp|text|在工作台中，右键单击有问题的表，然后单击"Select+Rows+Limit+1000“。它是弹出菜单中的第一个选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Inside the workbench right click the table in question and click "Select Rows - Limit 1000." It's the first option in the pop-up menu.

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/870612c783b96e6066997d6d365a10a9.png|imageAlt|blocks|key|an2qf|text|要在每个数据库下方的左侧面板上获得方便的表列表，您必须单击左侧面板右上角的小图标。至少在Win7上的MySQL+Workbench+6.3CE中，这可以获得完整的表列表。|unstyled|depth|inlineStyleRanges|entityRanges|2m4dl|请看我的截图来解释。|an6cq|3odfo|?|atomic|offset|length|97fnn|asfk8|​|dm3df|遗憾的是，这个图标甚至没有鼠标悬停标题属性，所以我很幸运地猜到了它。^0|0|0|0|0|1|0|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|W|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|X|H|@]|I|@]|6|$]]|$B|L|D|-4|2|F|G|Y|H|@]|I|@]|6|$]]|$B|M|D|N|2|O|G|Z|H|@]|I|@$P|10|Q|11|B|12]]|6|$]]|$B|R|D|-4|2|F|G|13|H|@]|I|@]|6|$]]|$B|S|D|T|2|F|G|14|H|@]|I|@]|6|$]]|$B|U|D|V|2|F|G|15|H|@]|I|@]|6|$]]]]

To get the convenient list of tables on the left panel below each database you have to click the tiny icon on the top right of the left panel. At least in MySQL Workbench 6.3 CE on Win7 this worked to get the full list of tables. 

See my screenshot to explain.<a href="https://i.stack.imgur.com/hTCc6.png" rel="noreferrer"><img src="https://i.stack.imgur.com/hTCc6.png" alt="enter image description here"></a>

Sadly this icon not even has a mouseover title attribute, so it was a lucky guess that I found it.

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/1ea4c39bcd50e294a21f7f08a4df9171.png|imageAlt|1|https://ask.qcloudimg.com/http-save/actteam/70357b11ac2aec6f1b4bd746a6d9cf6a.pngg|blocks|key|4eb6k|text|第一步-打开本地实例MySql；|unstyled|depth|inlineStyleRanges|entityRanges|4f2do|第二个-单击schemas在屏幕的左中角：|offset|length|style|CODE|alk70|55v2v|?|atomic|dgr8q|5k56d|第三--这样你就可以看到你的表格内容了：|e8ebn|58etq|63edq^0|0|6|7|0|0|0|1|0|0|0|0|0|0|1|1|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]|A|$2|3|4|5|6|$7|B|9|-4]]]|C|@$D|E|F|G|2|H|I|11|J|@]|K|@]|6|$]]|$D|L|F|M|2|H|I|12|J|@$N|13|O|14|P|Q]]|K|@]|6|$]]|$D|R|F|-4|2|H|I|15|J|@]|K|@]|6|$]]|$D|S|F|T|2|U|I|16|J|@]|K|@$N|17|O|18|D|19]]|6|$]]|$D|V|F|-4|2|H|I|1A|J|@]|K|@]|6|$]]|$D|W|F|X|2|H|I|1B|J|@]|K|@]|6|$]]|$D|Y|F|-4|2|H|I|1C|J|@]|K|@]|6|$]]|$D|Z|F|T|2|U|I|1D|J|@]|K|@$N|1E|O|1F|D|1G]]|6|$]]|$D|10|F|-4|2|H|I|1H|J|@]|K|@]|6|$]]]]

1st - Go open Local instance MySql;
2nd - Click on <code>schemas</code> on the left-middle of the screen:
<img src="https://i.stack.imgur.com/Fzung.png" width="200" />
3rd - Like this you will see your table contents:
<img src="https://i.stack.imgur.com/GtDFB.pngg" width="200" />

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/f93ecc75b6f5f1e16f88b01dd46654b3.png|imageAlt|blocks|key|55bp2|text|上面所有的答案都很棒。只缺少一样东西，请务必拖动灰色按钮以查看表格(第2步)：|unstyled|depth|inlineStyleRanges|entityRanges|9qjs5|?|atomic|offset|length|5p933|387j3|​^0|0|0|1|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|R|H|@]|I|@]|6|$]]|$B|J|D|K|2|L|G|S|H|@]|I|@$M|T|N|U|B|V]]|6|$]]|$B|O|D|-4|2|F|G|W|H|@]|I|@]|6|$]]|$B|P|D|Q|2|F|G|X|H|@]|I|@]|6|$]]]]

All the answers above are great.
Only one thing is missing, be sure to drag the grey buttons to see the table (step number 2):

<a href="https://i.stack.imgur.com/72n7f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/72n7f.png" alt="enter image description here"></a>

entityMap|blocks|key|3n01j|text|您必须打开数据库连接，而不是具有架构的工作台文件。它看起来有点奇怪，但当你意识到你正在编辑的东西时，它是有意义的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|u26a|因此，转到主页选项卡，双击数据库连接(如果您还没有数据库连接，请创建它)并享受乐趣。^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

You have to open database connection, not workbench file with schema. It looks a bit wierd, but it makes sense when you realize what you are editing.

So, go to home tab, double click database connection (create it if you don't have it yet) and have fun.

entityMap|blocks|key|4t3qd|text|在显示前1000条记录之后，您可以通过单击结果网格标题中"Fetch+row：“旁边的图标来对它们进行分页。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

After displaying the first 1000 records, you can page through them by clicking on the icon beside "Fetch rows:" in the header of the result grid.

How can I view table contents in Mysql workbench GUI? I mean, not from command line.

How to view table contents in Mysql Workbench GUI?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 如何在Mysql工作台GUI中查看表内容？我是说，不是从命令行。

问如何在Mysql Workbench GUI中查看表内容？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Mysql Workbench GUI中查看表内容？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Mysql Workbench GUI中查看表内容？
EN