02.08.2014, 21:36
Hi,
It'is possible to make that query i want to update some things, but a lot of players. And i need to create a lot of queries of update and it take a while when update. For ex:
I have in mysql database a fields:
Name | Food
Killer | 5
NoKiller | 10
....
And i do food --, and i need to update this to database, i load how much they have and how i said that ammount of food i make -- and with mysql update i make new food amount, but this make a lot of queries for each player. It'is will be very good to make it in one query taking all players.
It'is possible to make that query i want to update some things, but a lot of players. And i need to create a lot of queries of update and it take a while when update. For ex:
I have in mysql database a fields:
Name | Food
Killer | 5
NoKiller | 10
....
And i do food --, and i need to update this to database, i load how much they have and how i said that ammount of food i make -- and with mysql update i make new food amount, but this make a lot of queries for each player. It'is will be very good to make it in one query taking all players.