Posted By

Kcko on 07/23/14


Tagged

mysql delete limit


Versions (?)

Delete from table with limit (mySQL)


 / Published in: MySQL
 

Delete from table with limit (mySQL)

  1. DELETE FROM table
  2. WHERE ID IN
  3. (
  4. SELECT ID
  5. FROM
  6. (
  7. SELECT ID
  8. FROM table
  9. WHERE Type = 'TEST'
  10. ORDER BY ID
  11. LIMIT 30,60
  12. ) a
  13. )

Report this snippet  

You need to login to post a comment.