dland
2021-01-14 21:49:37
This sounds like a really strange need, but who am I to judge? :)
I would simply rely on the primary key:
DELETE FROM table WHERE id_table = (SELECT id_table FROM table LIMIT 1 OFFSET 6)
update: oh, so you don't have a primary key? You can join on the whole row this way (assuming it has five columns named a, b, c, d, e):
DELETE t
FROM table t
INNER JOIN (
SELECT a, b, c, d, e
FROM table
ORDER BY a, b, c, d, e
LIMIT 1 OFFSET 6
) ROW6 USING (a, b, c, d, e);
Any subset of columns (e.g. a, c, d) that uniquely identify a row will do the trick (and is probably what you need as a primary key anyway).
Edit: Added an ORDER BY clause as per The Impaler's excellent advice. That's what you get for knocking an example up quickly.
热门帖子
热门github
6
Oh wow that looks like the exact strange thing i am looking for :) will test by todays evening. Thx for the input so far!
LIMIT/OFFSETwithoutORDER BYrarely makes sense.is the same possible with '' logic? DELETE t FROM table t INNER JOIN ( SELECT * FROM table LIMIT 1 OFFSET 6 ) ROW6 USING ('');
Offhand, I don't thing
USING(*)is legal syntax. You will probably need to use theinformation_schema.columnstable to contruct the column names dynamically.