如何在 Mysql Workbench GUI 中查看表格内容？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18644812/
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
How to view table contents in Mysql Workbench GUI?
提问by alwbtc
How can I view table contents in Mysql workbench GUI? I mean, not from command line.
如何在 Mysql 工作台 GUI 中查看表内容？我的意思是，不是从命令行。
回答by Mike Lischke
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.
首先从主屏幕打开与服务器的连接 (SQL IDE)。然后使用架构树中的上下文菜单运行一个查询，该查询仅从所选表中选择行。附带的 LIMIT 是为了避免意外读取太多行。可以在首选项对话框中关闭（或调整）此限制。
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:
然而，这种快速选择行的方法不是很灵活。通常，您会在编辑器中使用附加条件（例如排序顺序）运行查询（文件/新查询选项卡）：
回答by chronon
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.
在工作台内右键单击有问题的表，然后单击“选择行 - 限制 1000”。这是弹出菜单中的第一个选项。
回答by aravithapa
Select Database , select table and click icon as shown in picture.
选择 Database ，选择 table 并单击图标，如图所示。
回答by domih
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.
要在每个数据库下方的左侧面板上获得方便的表列表，您必须单击左侧面板右上角的小图标。至少在 Win7 上的 MySQL Workbench 6.3 CE 中，这可以获取完整的表列表。
See my screenshot to explain.
看我的截图来解释。
Sadly this icon not even has a mouseover title attribute, so it was a lucky guess that I found it.
可悲的是，这个图标甚至没有鼠标悬停标题属性，所以我很幸运地找到了它。
回答by mustapha mekhatria
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):
上面所有的答案都很棒。只缺少一件事，请务必拖动灰色按钮以查看表格（第 2 步）：
回答by Josef Kufner
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.
因此，转到主页选项卡，双击数据库连接（如果您还没有，请创建它）并玩得开心。
回答by Rob
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.
显示前 1000 条记录后，您可以通过单击结果网格标题中“获取行：”旁边的图标来翻阅它们。
