Delete from table with limit (mySQL) - MySQL Snipplr Social Repository

Revision: 66941

at July 23, 2014 23:04 by Kcko

Initial Code

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

Initial URL

Initial Description

Delete from table with limit (mySQL)

Initial Title

Delete from table with limit (mySQL)

Initial Tags

mysql

Initial Language

MySQL