Solved [MySQL] Deleting account with no characters

[Don Daniello]

Hi,
I have question to some advanced users of MySQL.
I want to delete accounts which don't have any characters.
I have over 16 000 accounts and only 2 000 players (after database cleaning).
I know it requires advanced MySQL code with 'If's but I don't know how to do this.

Could you help me ?
Ofc reput point as reward

 

[Don Daniello]

Solution for deleting accounts with no characters:

SELECT * FROM accounts WHERE id NOT IN (SELECT account_id FROM players);

 

[Mikuch]

if i`m not wrong
better backup database before it

DELETE FROM accounts WHERE name NOT IN (SELECT name FROM players);

 

[TriamerA]

If you're not sure about it change delete from for select from and check that out ;]

 

[Don Daniello]

I did it yesterday, triamerka
I forgot to say that it work, thanks & rep Mikuch.

 

[WTF.Error]

crazy ?



DELETE FROM accounts WHERE name NOT IN (SELECT name FROM players);

delete all accounts where name of player not = ?
omg.


correct command.

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

 

[ninexin]

@WTF.Error Thxx works perfect for me i repd u
thx