Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to refresh a table in mysql workbench

I inserted data to mysql table 'table1' using java.But in the table in the workbench doesn't updated.When I retrive that table using java,inserted data using java will be shown.How to refresh my 'table1' table in workbench when I insert new data using java?

like image 992
Heshan Nipuna Avatar asked Oct 21 '16 02:10

Heshan Nipuna


1 Answers

Workbench doesn't automatically refresh table data on INSERT or UPDATE etc, so assuming you're viewing the table in question you should have a 'Navigator' pane open to the left.

If you expand the database you're working on, and find the relevant table there should be a few icons to the right of the table name. Click on the table symbol with the lightning bolt to execute a SELECT * on the table.

Referring to the image below it is the 'Select' button.

Navigator Pane

like image 195
Daniel Waghorn Avatar answered Oct 27 '22 21:10

Daniel Waghorn