How to view table contents in Mysql Workbench GUI?

MysqlUser InterfaceMysql Workbench

Mysql Problem Overview

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

Mysql Solutions

Solution 1 - Mysql

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.

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:

enter image description here

Solution 2 - Mysql

Select Database , select table and click icon as shown in picture.enter image description here

Solution 3 - Mysql

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.

Solution 4 - Mysql

1st - Go open Local instance MySql;

2nd - Click on schemas on the left-middle of the screen:

https://i.stack.imgur.com/Fzung.png" width="200" />

3rd - Like this you will see your table contents:

https://i.stack.imgur.com/GtDFB.pngg" width="200" />

Solution 5 - Mysql

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.enter image description here

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

Solution 6 - Mysql

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):

enter image description here

Solution 7 - Mysql

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.

Solution 8 - Mysql

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.

Categories
Recommended Mysql Solutions
Recommended User Interface Solutions
Recommended Mysql Workbench Solutions

Previous Solution:

Set Value for ace editor without selecting the whole editor

Ace Editor

Next Solution:

Find common substring between two strings

PythonStringAlgorithmTime ComplexityDynamic Programming

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionalwbtcView Question on Stackoverflow
Solution 1 - MysqlMike LischkeView Answer on Stackoverflow
Solution 2 - MysqlaravithapaView Answer on Stackoverflow
Solution 3 - MysqlchrononView Answer on Stackoverflow
Solution 4 - MysqlElias PradoView Answer on Stackoverflow
Solution 5 - MysqldomihView Answer on Stackoverflow
Solution 6 - Mysqlmustapha mekhatriaView Answer on Stackoverflow
Solution 7 - MysqlJosef KufnerView Answer on Stackoverflow
Solution 8 - MysqlRobView Answer on Stackoverflow