[Joe_Goro]

question
in mysql how to delete all my server accounts exccept one named Xx3
as my Mysql

MyDB » accounts

how please

[Ballu Miaa]

I am giving the actual SQL Query.

Код:

DELETE FROM `yourdbname`.`yourtablename` WHERE NOT `yourtablename`.`fieldname` = "Xx3";

Edit this query according to your database details then you can execute it directly on phpmyadmin or you can make a command ingame to do this or something else u can think of.

[Konstantinos]

An example:

pawn Код:

DELETE FROM `users` WHERE `username` != 'Xx3'

[Joe_Goro]

thanks but i type those cmd after
# mysql -p Mysqluser
password:
# here?