How to view table contents in Mysql Workbench GUI?

mysql user-interface mysql-workbench
alwbtc picture alwbtc · Sep 5, 2013 · Viewed 150.4k times · Source

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

Answer

Mike Lischke picture Mike Lischke · Sep 6, 2013

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

Related questions

Is there a GUI tool for MYSQL with query builder feature?

I am using MySQL Workbench. I can't deny that it's a very good tool. Unfortunately it doesn't have a query builder feature. So I wonder if there is another one that has a query builder feature?

Read More
Database design: 3 types of users, separate or one table?

I have 3 types of users: Admins Suppliers Employees Each user type will have different user interface and access different types of data. Their only similarity is they are using one web application but they access totally different things. Is it …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More