Update query interrupted in workbench?

user_5031762 0
Viewed 5219

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

mysql-workbench mysql sql
2 Answers

Try limit to 100 rows, it worked for me. The options above the query window, beside the query button there is a option to limit the rows obtained. This might help you

user_113959270
Related