08.11.2016, 10:04
Your query max length will be the string length you've got. = 33
Then, take away "%d" as this will be replaced with a number. = 31
This number can maximum be 999,999,999 (without the commas, dont write it, imagine it). = 40
So in your case I would recommend a string length on 41-45 just to be sure. If this was a bank amount of cash, the max amount a integer can hold is: 2,147,483,647. That makes 1 more.
This is how you calculate the lengths
Код:
UPDATE `players` SET `money` = %d
Код:
UPDATE `players` SET `money` =
Код:
UPDATE `players` SET `money` = 999999999
This is how you calculate the lengths