MySQL – UPDATE query with LIMIT

by

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
)

More Related Contents:

  1. MySQL – UPDATE query based on SELECT Query
  2. MySQL, update multiple tables with one query
  3. Why does MYSQL higher LIMIT offset slow the query down?
  4. MySQL update table based on another tables value
  5. mysql update column with value from another table
  6. Using variable in a LIMIT clause in MySQL
  7. Maximum number of records in a MySQL database table
  8. UPDATE multiple tables in MySQL using LEFT JOIN
  9. Combining UNION and LIMIT operations in MySQL query
  10. MySQL error code: 1175 during UPDATE in MySQL Workbench
  11. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  12. How to set a maximum execution time for a mysql query?
  13. update multiple rows using limit in mysql?
  14. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  15. MySQL update a joined table
  16. MySQL JOIN with LIMIT 1 on joined table
  17. MySQL: update a field only if condition is met
  18. Advanced MySql Query: Update table with info from another table
  19. What are differences between INSERT and UPDATE in MySQL?
  20. MySql Query: Select top 3 rows from table for each category
  21. Does MySQL overwrite a column of same value on update?
  22. MySQL UPDATE syntax with multiple tables using WHERE clause
  23. mySQL UPDATE query returns “0 rows affected”
  24. How to create and insert a JSON object using MySQL queries?
  25. The best way to remove value from SET field?
  26. MySQL: How do I use delimiters in triggers?
  27. Update MySQL with if condition
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields
  30. MySQL update statement to store ranking positions

Leave a Comment