Android Question mysql weird problem

tufanv

Expert
Licensed User
Longtime User
Hello

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 ?
 

Straker

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
Top