如何在Mysql Workbench GUI中查看表内容? [英] How to view table contents in Mysql Workbench GUI?

问题描述

如何在Mysql工作台GUI中查看表内容?我的意思是，不是从命令行来的.

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

推荐答案

首先从主屏幕打开到服务器的连接(SQL IDE).然后，使用架构树中的上下文菜单运行查询，该查询仅从所选表中选择行.附加的LIMIT是为了避免意外读取太多行.可以在首选项"对话框中关闭(或调整)此限制.

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.

但是，这种快速选择行的方法不是很灵活.通常，您会在编辑器中使用其他条件(例如排序顺序)运行查询(文件"/新查询"选项卡):

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:

这篇关于如何在Mysql Workbench GUI中查看表内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！