data editing in query results
Why is it impossible to edit the data from query results? In some cases editing the table data directly is a workable solution but what about when you need to edit data from a query joining two or more tables? Actually that's true for any query even one like 'select * from <table>;'.
Is this behavior unique to MySQL or HeidiSQL? I've looked at other guis and they all behave alike in this regard but it doesn't make sense. I've worked with Access for many years and it sets no such limitations.
It's currently impossible as HeidiSQL needs to do a more deeper check of the returned result set of a custom query. In the data grid, the table cannot be joined and therefore it is simple to compose UPDATE and DELETE queries. However, I'd be a fan of editable query results and will implement that after the 5.0 GA release.
Please login to leave a reply, or register at first.