|
   |
| Модератор форума: Dimitro |
| Форум TrinityCore [TrinityCore] Help Помогите с Sql запросом. |
| Помогите с Sql запросом. |
Помогите правильно запрос сделать что бы очистить в таблицах инфу всю.
Код DELETE FROM `auth` where level<3; DELETE FROM `account_access` where guid not in (select guid from `auth`); DELETE FROM `account_authenticator` where guid not in (select guid from `auth`); DELETE FROM `account_banned` where guid not in (select guid from `auth`); DELETE FROM `account_muted` where guid not in (select guid from `auth`); DELETE FROM `account_reputation` where guid not in (select guid from `auth`); DELETE FROM `accounts_extra` where owner not in (select guid from `auth`); DELETE FROM `black_ip` where guid not in (select guid from `auth`); DELETE FROM `friend_invite` where guid not in (select guid from `auth`); DELETE FROM `ibf_members` where guid not in (select guid from `auth`); DELETE FROM `passwd_queue` where guid not in (select guid from `auth`); DELETE FROM `realmauth` where guid not in (select guid from `auth`); DELETE FROM `character_ticket` where guid not in (select guid from `auth`); DELETE FROM `character_tutorial` where account not in (select account from `auth`); DELETE FROM `corpse` where `player` not in (select guid from `auth`); DELETE FROM `vip_accounts` where guid not in (SELECT guid FROM `auth`);
○RO3M2○ Programming IT
Сообщение # 1 написано 01.08.2015 в 14:54
|
Цитата FreeCat (  )эм зайти в каждую таблицу и удалить все через выделение ctr+a и шифт делете Тебе легко говорить 33к аккаунтов ) и каждый удали) Добавлено (01.08.2015, 20:02) --------------------------------------------- Цитата distmister ( )Ro3m2, TRUNCATE TABLE имя_таблицы. Спасиб.
○RO3M2○ Programming IT
|
| |||
| |||