sql queries

[Indenpedens]

witam
potrzebuje takich 3 zapytan do bazy danych
- usuwa wszystkie accounty i playersy z bazy to osobno chyba
- i czysci wszystkie domki

 

[elf]

TRUNCATE TABLE `players`; TRUNCATE TABLE `accounts`;
UPDATE `houses` SET `owner` = 0, `paid` = 0, `warnings` = 0, `lastwarning` = 0; TRUNCATE TABLE `house_storage`; TRUNCATE TABLE `house_lists`; TRUNCATE TABLE `tiles`; TRUNCATE TABLE `tile_items`;

 

[Indenpedens]

ale nie chce truncate ;p

 

[Azi]

ale nie chce truncate ;p

 DELETE FROM `accounts`;
 DELETE FROM `players`;

 

[Indenpedens]

a jak wziac ze usuwasz wszystkie pomijajac acocunt manager

 

[Aleh]

DELETE FROM `players` WHERE `name` <> 'Account Manager';

 

[Azi]

DELETE `accounts` WHERE `accounts`.`id` != (SELECT `account_id` FROM `players` WHERE `players`.`name`='Account Manager' LIMIT 1);
DELETE `players` WHERE `players`.`name` != 'Account Manager'

 

[trou]

DELETE `accounts` WHERE `accounts`.`id` != (SELECT `account_id` FROM `players` WHERE `players`.`name`='Account Manager' LIMIT 1);

mistrzu,
dla 1000 kont w bazie Twoje zapytanie wykona 1000+1 zapytań.

 

[Sprite]

np.

DELETE FROM `theforgottenserver`.`accounts` WHERE NOT `accounts`.`id` = 1

 

[Santera]

DELETE FROM `players` WHERE `id` NOT IN (x); - Gdzie x to id Account Managera
DELETE FROM `accounts` WHERE `id` NOT IN (x); - Gdzie x to id Account Managera