MySQL - UPDATE query with LIMIT

Question

I want to update rows in my table with starting from 1001 to next 1000.

I tried with following query:

UPDATE `oltp_db`.`users` SET p_id = 3 LIMIT 1001, 1000 

1. This is giving me syntax error. Is this correct? am I doing any mistake here.
2. Can we limit update in this way?

Also, the rows that I am trying to update are having Null value for the column p_id which is having data type INTEGER. Due to this I am not even able to update using following query:

UPDATE `oltp_db`.`users` SET p_id = 3 WHERE p_id = null 

1. Is my above query correct?
2. What can be done to achieve this?

Answer 1

If you want to update multiple rows using limit in MySQL you can use this construct:

UPDATE table_name SET name='test' WHERE id IN (     SELECT id FROM (         SELECT id FROM table_name          ORDER BY id ASC           LIMIT 0, 10     ) tmp )