View Window for Data of Current Table

[Ritesh]

Quote:

It would be really nice if a separate window or child window displays the data of the current table selected. It's burdensome to rt click the table and select view data. If this can be done, it would be better if the user can immediately make inserts, deletes, and updates to the selected table within that window.

You can do that in SQLyog. Just select the table in the Object Browser and select Insert/Update data from the popup menu or press Ctrl+Enter.

In the window, you can even Insert, update or delete data.

[Ritesh]

Hi,

The omission of this “feature” is intentional.

SQLyog is optimized for remote connections and it is the tool of choice if you want to access MySql databases hosted with your ISP.

We dont want to generate unnecesary traffic everytime a user clicks on a table. If you want to insert / update data you need to do go thru an extra step.

In fact, other MySQL front-ends that bring up the update window “very quickly” even if the the result set if huge use mysql_use_result() which requires you to retrieve *all* the rows even if you determine in mid-retrieval that you've found the information you were looking for. Therefore if you are have not scrolled till the last row of the table, the entire table remains *locked*. Other connections cannot update the table.

This is unacceptable for production servers. If you want to perform insert / updates on a table, the best way is to write a query which filters the rows that you want to update and press F8 to perform updates on the resultset.

Hope this helps

[Author]

Posts