How to view contents of table in mysql-workbench

Question

Hi everyone am fairly new to mysql, I made a java program that stores data in mysql database. I am using this tool called mysql-workbench that can create databases, tables and much more. What I wanted to do is to view all the contents of the table I just populated with data in my java program. I know that one can view all the contents of a table using some SQL scripts, however am wondering if mysql-workbench can display all the contents in the table without entering SELECT mysql script in a sort of tabular form or similar to how they display contents of table in phpMyAdmin.

The reason why I wanted to do this is that I have 2-3k entries in that table and using a console is kind of messy. Any help or suggestions on how to do this? Thanks in advance.

score 10 · Accepted Answer · answered Sep 17 '12 at 23:14

10

After you create a connection to your database, execute the following two commands: USE <DATABASE NAME>; SELECT * FROM <TABLE NAME>;

Then MySQL Workbench will show another pane with the results. This will be the entire contents of the table.

answered Sep 17 '12 at 23:14

psyklopz

216
2
3

score 1 · Answer 2 · answered Sep 17 '12 at 23:16

1

You certainly can.

This article: Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts gives you step by step instructions (with screenshots). Enjoy!

answered Sep 17 '12 at 23:16

xelco52

111
3

score 0 · Answer 3 · answered Apr 23 '15 at 19:19

OP said: "However I was looking for a "just click and click" solution if you know what I mean. "

You can also right click the table you are interested in via the schema inspector tab on the left, and select the option: "Select Rows - Limit 1,000" for a quick view, obviously limited to 1,000 results.

How to view contents of table in mysql-workbench

3 Answers3