PDA

View Full Version : Yo guys


NeXTGoD
20/06/2019, 10:41 PM
Yo Im using MySQL and I want to set all my accounts (1,207,000 accounts) Score to 0 BUT only if the account has more than 200 score, if the account has less than 200 score then skip it

What query to use?

oMa37
20/06/2019, 10:47 PM
UPDATE `table` SET `Score` = 0 WHERE `Score` > 200

Haven't used mysql for a long time but I think this should work.

Symon
21/06/2019, 04:27 PM
oMa37's query should do its job. My question is another one...

How did you achieved 1+ milion of accounts? I'm not even sure if SaMp players are equiparable to the number you said...

Mobtiesgangsa
21/06/2019, 09:44 PM
oMa37's query should do its job. My question is another one...

How did you achieved 1+ milion of accounts? I'm not even sure if SaMp players are equiparable to the number you said...

Fun fact: SA-MP can't but MySQL can depending on storage data can be inserted as many times with different values and different data.

a simple factor achieving a 1M+ above registered users could, is some they forgot there password the main reason and users/players create new accounts.

as for score...

score > 200: this is if player has above 200+ score
score < 201: this is if player has below 200 score

Symon
21/06/2019, 10:06 PM
Yes but how the hell you can reach 1 MILION of server accounts? I think not even LSRP has so many registered players, lol.

SiaReyes
22/06/2019, 05:10 AM
Yes but how the hell you can reach 1 MILION of server accounts? I think not even LSRP has so many registered players, lol.

Auto_Increment = 1,207,000 *Cough* , JK

Bolex_
22/06/2019, 11:33 AM
Multiple accounts during all the years.