AAC [PHPMyAdmin]Delete Account without players

[potinho]

Is there a way to delete (by some SQL script) the accounts that don't have players? If it's relevant information, I use Gesior.

 

[slaw]

Yes its possible with single query.

Try this (not tested), so maybe try this on test database, but should work.

DELETE FROM accounts
 WHERE NOT EXISTS(SELECT NULL
    FROM players p
    WHERE p.account_id = id)

 

[potinho]

Yes its possible with single query.

Try this (not tested), so maybe try this on test database, but should work.

DELETE FROM accounts
 WHERE NOT EXISTS(SELECT NULL
    FROM players p
    WHERE p.account_id = id)

bring back all accounts

 

[slaw]

wat. it should not delete any accounts because query was wrong.

anyways I said use on test database - your fault.

Here is the fixed query:

DELETE FROM accounts
 WHERE id NOT IN (SELECT p.account_id 
                        FROM players p)

 

[potinho]

Works, thank you