Posted By

Kcko on 07/23/14

Tagged

Viewed 4080 times

Favorited by 0 user(s)

/ Published in: MySQL

Delete from table with limit (mySQL)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

DELETE FROM table
WHERE ID IN
(
SELECT ID
FROM
(
SELECT ID
FROM table
WHERE Type = 'TEST'
ORDER BY ID
LIMIT 30,60
) a
)

You need to login to view comments.