Kcko/delete from table with limit.sql

Created June 3, 2014 20:53

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Kcko/091882edc3ed62e4b82e.js"></script>
Save Kcko/091882edc3ed62e4b82e to your computer and use it in GitHub Desktop.

Download ZIP

Delete from table with limit (first X rows excluded)

Raw

delete from table with limit.sql

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment