Simple SQL query to remove Guild Members but NO Guild Leaders

[Olrox]

Hello just asking... how to make 2 simple queries on a rathena database.

Query 1:

How a sql query on a rAthena database, would be... to remove all the lines into the 'guild_member' table but not the lines that has char guild master that are into the 'guild' table.

the 'char_id' column is common on both tables.

Query 2:

To do a query to set the 'guild_id' column inside the 'char' table to the value = '0' to all the lines but, not the lines that has char guild master into the 'guild' table

Again, the 'char_id' column is common on bot 'char' and 'guild' table on this one.

Why I'm doing this? I'm reducing the max_guild_size of one server, and I need to clean the guild members, so all the guilds will have only 1 member (guild master).

Thanks in advance

Edited March 23, 2012 by Olrox

[Brian]

DELETE FROM guild_member WHERE char_id NOT IN (SELECT char_id FROM guild);

UPDATE `char` SET guild_id=0 WHERE char_id NOT IN (SELECT char_id FROM guild);

edit: you're welcome!

Edited March 23, 2012 by Brian

[Olrox]

Thanks brian!