-
Notifications
You must be signed in to change notification settings - Fork 436
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Allow editing values of SELECT query Result #1952
Comments
This is already possible. The only requirement is that HeidiSQL is able to determine the table name of the result, and that all columns derive from a single table. |
@ansgarbecker I can't confirm it. It knows the name but I still can't change data: |
Ok, then please select the primary key column(s) as well. |
Yes, that workaround works. But it would consume less time, if I could just change it without having to figure out the primary key column(s) first and changing my query accordingly. Another problem is, that people need to have that knowledge, otherwise they will think it is a bug / missing feature, like me... |
You say in DBeaver it works. How does it work there in such a situation? How does an UPDATE look like when you edit a value there? |
Well, I just execute my SELECT e.g.
Then I can simply edit the entries and click on save at the end. |
My question was how the |
I see. Initially this window popped up: I clicked on Use All Columns. Then after saving it executed these queries:
And then a SELECT afterwards:
|
Quite dangerous, this "Use All (selected) columns" button. You probably update more than one row then. Worst case would be you overwrite an important setting with that, and you even don't know you did it. Is that "Use All columns" really something HeidiSQL should provide? |
It should be possible to edit values of a SELECT query result.
This would save alot of time.
In other software like DBeaver it works.
The text was updated successfully, but these errors were encountered: