http://dev.mysql.com/doc/refman/5.0/en/integer-types.html The integer overflow will set the max allowed number in the DB as 2147483647 So you need bigint datatype for storing bigger integer
This is known as the ‘Hamming Weight’, ‘popcount’ or ‘sideways addition’. Some CPUs have a single built-in instruction to do it and others have parallel instructions which act on bit vectors. Instructions like x86’s popcnt (on CPUs where it’s supported) will almost certainly be fastest for a single integer. Some other architectures may have a … Read more
I was a member of the IEEE-754 committee, I’ll try to help clarify things a bit. First off, floating-point numbers are not real numbers, and floating-point arithmetic does not satisfy the axioms of real arithmetic. Trichotomy is not the only property of real arithmetic that does not hold for floats, nor even the most important. … Read more
How to count the number of set bits in a 32-bit integer?