Some of these approaches seem a little complicated, and I generally do this as: Given table table, want to unique it on (field1, field2) keeping the row with the max field3: DELETE FROM table USING table alias WHERE table.field1 = alias.field1 AND table.field2 = alias.field2 AND table.max_field < alias.max_field For example, I have a table, … Read more
DELETE FROM `table` WHERE (whatever criteria) ORDER BY `id` LIMIT 1000 Wash, rinse, repeat until zero rows affected. Maybe in a script that sleeps for a second or three between iterations.
You cannot delete the records that way, the main issue being that you cannot use a subquery to specify the value of a LIMIT clause. This works (tested in MySQL 5.0.67): DELETE FROM `table` WHERE id NOT IN ( SELECT id FROM ( SELECT id FROM `table` ORDER BY id DESC LIMIT 42 — keep … Read more
You can just remove the entire graph directory with rm -rf, because Neo4j is not storing anything outside that: rm -rf data/* Also, you can of course iterate through all nodes and delete their relationships and the nodes themselves, but that might be too costly just for testing …
For others that find this question looking to delete while using a subquery, I leave you this example for outsmarting MySQL (even if some people seem to think it cannot be done): DELETE e.* FROM tableE e WHERE id IN (SELECT id FROM tableE WHERE arg = 1 AND foo = ‘bar’); will give you … Read more
DELETE FROM konta WHERE taken <> ”;
You need to identify the primary key in TableA in order to delete the correct record. The primary key may be a single column or a combination of several columns that uniquely identifies a row in the table. If there is no primary key, then the ROWID pseudo column may be used as the primary … Read more
If you need to delete based on a list, you can use IN: DELETE FROM your_table WHERE id IN (value1, value2, …); If you need to delete based on the result of a query, you can also use IN: DELETE FROM your_table WHERE id IN (select aColumn from …); (Notice that the subquery must return … Read more
Use a JOIN in the DELETE statement. DELETE p, pa FROM pets p JOIN pets_activities pa ON pa.id = p.pet_id WHERE p.order > :order AND p.pet_id = :pet_id Alternatively you can use… DELETE pa FROM pets_activities pa JOIN pets p ON pa.id = p.pet_id WHERE p.order > :order AND p.pet_id = :pet_id …to delete only … Read more
Add .* to s in your first line. Try: DELETE s.* FROM spawnlist s INNER JOIN npc n ON s.npc_templateid = n.idTemplate WHERE (n.type = “monster”);