Android Question mysql weird problem


Licensed User
Longtime User

I have an integer value in my sql called money
when i try to set it to 3,000,000,000 within the phpmyadmin ( via update tblusers set money ="3000000000"
it accepts the query than i go check the value of money via phpmyadmin again it says the money is : 2147483647

it is always the same .

Have any ideas ?


Active Member
Licensed User
Longtime User
Simply because a MySql Int type is 4 bytes and the maximum number is 2147483647.
You should use a bigint field (you can ALTER TABLE...)
Upvote 0