Login

jblu / Unmanic database file scripts

Last active 6 months ago

Like 0

delete.sql · 342 B · MySQL Raw

1	DELETE FROM historictaskprobe
2	WHERE EXISTS (
3	SELECT 1 FROM historictaskprobe p2
4	WHERE historictaskprobe.size = p2.size
5	AND historictaskprobe.basename = p2.basename
6	AND historictaskprobe.abspath = p2.abspath
7	AND historictaskprobe.size = p2.size
8	AND historictaskprobe.type = p2.type
9	AND historictaskprobe.historictask_id > p2.historictask_id
10	);

select.sql · 344 B · MySQL Raw

1	SELECT * FROM historictaskprobe
2	WHERE EXISTS (
3	SELECT 1 FROM historictaskprobe p2
4	WHERE historictaskprobe.size = p2.size
5	AND historictaskprobe.basename = p2.basename
6	AND historictaskprobe.abspath = p2.abspath
7	AND historictaskprobe.size = p2.size
8	AND historictaskprobe.type = p2.type
9	AND historictaskprobe.historictask_id > p2.historictask_id
10	);