Editing data through a View causes 1221 Incorrect Usage of UPDATE and LIMIT

sonicsmooth posted 3 months ago in General

Using HeidiSQL 9.5.0.5196 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.

thanks

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