database

[Nerevr back]

hello guys i want command to clean database from accounts and players and guilds and house owner but keep account number 1...
i will be thanks if someone helped me


sorry for my bad english
i use 0.4 idk if that important or now

 

[Fiodor]

lets say your field is an id = 5

then

select * from your_table where id !=5

this should help you

 

[Nerevr back]

this should help you

what this?

 

[Ashwalker]

DELETE FROM "table_name"
WHERE id != 1;

 

[Il Knight]

Players =

DELETE FROM `players` WHERE `id` > 0

Accounts =

DELETE FROM `accounts` WHERE `id` > 1

 

[Il Knight]

houses try with
DELETE FROM `houses` WHERE `bid` > 0
idk if its bid or rent or owner, check your database

and you need to clean the market offers, history. good luck.