MySQL LIMIT on DELETE statement

by

simply use 

DELETE FROM test WHERE 1= 1 LIMIT 10

More Related Contents:

  1. Mysql delete statement with limit
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. Remove duplicate rows in MySQL
  4. How to delete from multiple tables in MySQL?
  5. Why does MYSQL higher LIMIT offset slow the query down?
  6. Using variable in a LIMIT clause in MySQL
  7. Maximum number of records in a MySQL database table
  8. Combining UNION and LIMIT operations in MySQL query
  9. MySQL DELETE FROM with subquery as condition
  10. SQL query: Delete all records from the table except latest N?
  11. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  12. MySQL – UPDATE query with LIMIT
  13. How to set a maximum execution time for a mysql query?
  14. Deleting rows with MySQL LEFT JOIN
  15. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  16. SQL DELETE with JOIN another table for WHERE condition
  17. MySQL JOIN with LIMIT 1 on joined table
  18. MySql Query: Select top 3 rows from table for each category
  19. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  20. How do I delete all the duplicate records in a MySQL table without temp tables
  21. Delete from one table with join
  22. UPDATE with ORDER BY and LIMIT not working in MYSQL
  23. Delete all rows with timestamp older than x days
  24. Deleting a row based on the max value
  25. delete rows from multiple tables
  26. Deleting millions of rows in MySQL
  27. How to group by week in MySQL?
  28. Mysql order by specific ID values
  29. MySQL – SQL_BIG_SELECTS
  30. Optimistic locking in MySQL

Leave a Comment