Запрос аккаунты на которых нет персонажей:
Код:
#Выборка
SELECT * FROM `realmd`.`account` where `id` not in (select account from `mangos`.`character`);
#Удаление:
DELETE FROM `realmd`.`account` where `id` not in (select account from `mangos`.`character`);
Старое помойму
Новое:
Код:
#Выборка
SELECT * FROM `realmd`.`account` where `id` not in (select account from `characters`.`characters`);
#Удаление:
DELETE FROM `realmd`.`account` where `id` not in (select account from `characters`.`characters`);