distal-attribute
distal-attribute
distal-attribute
distal-attribute

Any way to edit a Query Result from table w/no PK or index?

User, date Message
Written by Dave
5 years ago
Category: General
24 posts since Fri, 19 Sep 08
In HeidiSQL, I cannot manually edit a query result from a table that does not contain a PK or index.

Is there any way to circumvent this so that I can edit the table manually?

Thanks!
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
That's not possible without the risk of data loss which is the reason why HeidiSQL blocks editing in that case. You can surely bypass this blocking and write your own

UPDATE mytable SET foo=1 WHERE bar=2

queries into the query editor and run them by F9. But the risk will be the same. The easiest and most consistent way is to add a unique or primary key - which is always good and also helps in performance optimization.
Written by Dave
5 years ago
24 posts since Fri, 19 Sep 08
Thanks very much!
 

Please login to leave a reply, or register at first.