question - Printable Version

question - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: question (/showthread.php?tid=475886)

question - Joe_Goro - 15.11.2013

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

MyDB » accounts

how please

Re: question - Ballu Miaa - 15.11.2013

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.

Re: question - Konstantinos - 15.11.2013

An example:

pawn Код:

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

Re: question - Joe_Goro - 15.11.2013

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