snippetjavaModerate
How to view contents of table in mysql-workbench
Viewed 0 times
workbenchcontentsviewmysqlhowtable
Problem
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.
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.
Solution
After you create a connection to your database, execute the following two commands:
Then MySQL Workbench will show another pane with the results. This will be the entire contents of the table.
USE ;SELECT * FROM ;Then MySQL Workbench will show another pane with the results. This will be the entire contents of the table.
Context
StackExchange Database Administrators Q#24460, answer score: 10
Revisions (0)
No revisions yet.