Stop query when it run by condition

Question

have some update query

Update
    some_table
set 
    some_filed=some_data;

How to stop execute of query when for example some_table.id>1000? Is it possible? Need stop, because write event for scheduler for very large table (over 30kk rows) and want to update only 10k rows for each time.

some sort of where clause? And 30k rows really isn't that big of an updte. — Andrew, Jun 19 '14 at 14:44
Oh,you mean 30 million? That's a little more than 30k :) Trying to do that in batches is going to take a looong time. You might look into inserting into a new table, and doing your updates as part of the select into. — Andrew, Jun 19 '14 at 14:49
@disable1992 Oops, my mistake. http://stackoverflow.com/questions/6289729/mysql-update-query-with-limit was suggesting it — winkbrace, Jun 19 '14 at 14:49
@Andrew with performance of query (more difficult then example;) ) all fine, 23k rows for 250 seconds. But need limit by rows count for each event start. — disable1992, Jun 19 '14 at 14:52

score 1 · Answer 1 · answered Jun 19 '14 at 14:43

1

Update
    some_table
set 
    some_filed=some_data
WHERE
    id <= 1000;

Use a where clause?

answered Jun 19 '14 at 14:43

scragar

6,764
28
36

not good. Because it is event, and condition for id dynamically change – disable1992 Jun 19 '14 at 14:47

Stop query when it run by condition

1 Answers1