Support:Database Cleanup: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
Line 60:
DELETE FROM del2 WHERE EXISTS (SELECT null FROM kills WHERE kills.killed = charname AND killed_type='P');
DELETE FROM del2 WHERE EXISTS (SELECT null FROM kills WHERE kills.killer = charname AND killer_type='P');
</source>▼
-- check
SELECT username, count(*) FROM account, del2, characters WHERE account.username=del2.charname AND account.id=player_id
AND NOT EXISTS (SELECT null FROM del2 As t WHERE t.charname = characters.charname)
GROUP BY username
HAVING count(*) > 1;
SELECT username, count(*) FROM account, del2, characters As c1, characters As c2
WHERE account.id=c1.player_id AND c1.charname=del2.charname AND account.id=c2.player_id
AND NOT EXISTS (SELECT null FROM del2 As t WHERE t.charname = c2.charname)
GROUP BY username
HAVING count(*) > 1;
▲</source>
=== Delete ===
| |||