MySQL update limit MySQL update restriction statement usage

When MySQL is updated, data in a certain interval in the record must be updated using the where condition,

You can use limit to limit the number of updates! The test is as follows:

Update products set goods_number = goods_number + 10 order bygoods_id DESC limit 5, 10

This test is incorrect. The MySQL update statement cannot update the limit from the nth to the nth!

Error message: #1064-you have an error in your SQL syntax; check the manualthat corresponds to your MySQL Server version for the right syntaxto use near '10' at line 1

You can only use the following statement, or you can use the where Condition Statement to limit it.

Update products set goods_number = goods_number + 10 order bygoods_id DESC limit 10