Feature Suggestion

I was wondering if it was a good idea to add the feature to edit the tables directly. Like select the database, select a table, select Data tab and just modify values from there, then hit a button "Save" or something similar and the GUI will run queries to modify those cells on the server.

Thanks

Ilian

Hmm this sounds pretty exactly like it is implemented in HeidiSQL... Click a database, click a table and switch to data tab. Or how's that meant?

You can do that. However, there's only one caveat with direct editing; to have your edits applied, you must use either your up or down arrow key to select a next or previous row for your current row's changes to take place. Here's what I've discovered:

After entering data you:
TAB = no update
RETURN = no update
ENTER = no update
UP ARROW to previous row = UPDATES
DOWN ARROW to next row = UPDATES

Now... if you happen to keep TABbing to where it drops you to the next row, then it will update.

Oh, and another thing. If you enter data in a field and use your mouse to select a different row, you'll lose your changes. You must physically use your keyboard. Sucks, I know, but oh well, that's how it has to work.

I hope I didn't totally confuse you.

If you enter data in a field and use your mouse to select a different row, you'll lose your changes.

Just tested in rev1590. That's not true.

(If it was, that would be a bug.)

If you enter data in a field and use your mouse to select a different row, you'll lose your changes.

Just tested in rev1590. That's not true.

(If it was, that would be a bug.)

Changed data does indeed query correctly when using the mouse to select a different row. Thanks rosenfield for the correction.

Hi,

I was wondering if there's any setting to disable data updating when
navigating with the keys. I want to be able to update records only when
CTRL+Enter or clicking the POST button.

Thanks

P.S. Really nice work guys. I'm switching from MySQL Tools to HeidiSQL and
I'm very happy with it.

There is no setting for that automatism currently. Not sure if that would make so much sense.