Using HeidiSQL 18.104.22.16896 on Windows 10 x64, connecting via TCP/IP to MySQL 14.14 on Linux.
I have a view which is a JOIN of two tables. When I edit data from the view, I get SQL Error (1221): Incorrect usage of UPDATE and LIMIT.
If I remove the "LIMIT 1" from the query and try again, then it works.
It seems that phpmyadmin also adds this "LIMIT 1" to the update query, since I get the same error when I go through the web interface.
How can I update data through a view without this error, using the GUI?
Incidentally, I originally had my view as an OUTER JOIN and was getting a different error that seemed more logical than the limit 1 error.