CODEWITHSUNDEEP
mysqlsqlconditional-statements
disable1992
disable1992

Reputation: 4953

Stop query when it run by condition

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.

Upvotes: 0

Views: 476

Answers (1)

scragar
scragar

Reputation: 6824

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

Use a where clause?

Upvotes: 1

Related Questions