Update query interrupted in workbench?

Question

The first query returns an expected set of records but when I run the update query and refresh, It immediately says 'query interrupted' but there are no messages.

SELECT * FROM table WHERE value = 0;
UPDATE table SET value = 99 WHERE value = 0;

I can manually update the tables, so I don't think there is a permissions issue. What could be causing a query interruption in this case?

Version: 6.3.7

Answer 1

There is a default thousand-row limit in MySQL-Workbench. The SELECT query will return results but UPDATE will fail if the number of records to be updated exceeds one thousand. One option is to limit the number of records to be updated in the query itself or you can adjust the settings as stated in the documentation.