Feature Suggestion
| User, date | Message |
|---|---|
|
Written by King Ilian
5 years ago Category: Feature discussion 1 posts since Fri, 18 Jul 08 |
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 |
|
Written by ansgar
5 years ago 3958 posts since Fri, 07 Apr 06 |
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? |
|
Written by Dr. Dave
5 years ago 95 posts since Sun, 27 Jan 08 |
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. |
|
Written by rosenfield
5 years ago 127 posts since Wed, 24 Jan 07 |
Dr. Dave wrote: 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.) |
|
Written by Dr. Dave
5 years ago 95 posts since Sun, 27 Jan 08 |
rosenfield wrote: Dr. Dave wrote: If you enter data in a field and use your mouse to select a different row, you'll lose your changes. Changed data does indeed query correctly when using the mouse to select a different row. Thanks rosenfield for the correction. |
|
Written by Amenthes
4 years ago 2 posts since Wed, 21 Jan 09 |
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. |
|
Written by ansgar
4 years ago 3958 posts since Fri, 07 Apr 06 |
There is no setting for that automatism currently. Not sure if that would make so much sense. |
|
Please login to leave a reply, or register at first. |