Advanced Search

Delete from table with limit (mySQL)

/ Published in: MySQL
Save to your folder(s)
Delete from table with limit (mySQL)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.