09.09.2012, 09:57
Hi guys 
I have a question about updating dates in mysql db. Ok, so in my DB I have a primary key called 'Key' for each user what register at the server. When player leaves the server, I updating in database like this:
So ... what is better, to update in database like this:
or
Or doesn't matter?

I have a question about updating dates in mysql db. Ok, so in my DB I have a primary key called 'Key' for each user what register at the server. When player leaves the server, I updating in database like this:
pawn Код:
UPDATE `Players` SET `Bla Bla` = '%d', `Bla Bla 2` = '%d' WHERE `Name` = 'Player Name'
pawn Код:
UPDATE `Players` SET `Bla Bla` = '%d', `Bla Bla 2` = '%d' WHERE `Key` = 'Player Register ID'
pawn Код:
UPDATE `Players` SET `Bla Bla` = '%d', `Bla Bla 2` = '%d' WHERE `Name` = 'Player Name'