I have created a simple view using an inner join on a common field of two tables. The join field is the primary key in each of the two underlying tables. This view is "updatable" according to mySql.
I would like to be able to modify a field value through the view data grid in HeidiSQL. The field I would like to modify is not a key. Only one underlying table would be touched so this should be legal.
When I try this generates an UPDATE query which includes a LIMIT 1 at the end. This results in the SQL error / SQL Error (1221): Incorrect usage of UPDATE and LIMIT /
If I run the query manually without the LIMIT 1 the query succeeds with no problem.
Is there any way to remove the LIMIT 1 from the query generated by HeidiSQL in such a case?
(I could provide a full example, but I hope the issue is clear enough from this description.)