Length/Values1 what do i put there.
this is a collumn in one of my tables its bigint so the number can get increased by alot. its a point system. it asks for length/values whn i edit the name of the column but i dont understand what to put there. i know the number can be like up to 1,000,000 or more i read that online. but do i put max number or max characters. cause if the max number was to 1,000 then id put the number 4 cause 1,000 is four or five with the comma. or do i pu t like 1,000,000 in the length/values feild?
i dont understand the reason im asking is becuase i dont know if i do it wrong maybe it will get messed up and have too many i dont know if it will allow too many considering its limited to a number but i dont understand if the length/values is the character ammount or the actual number ? please helps
Jump to Post
http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html Use the language documentation before going to the forums please.
Jump to Post
Simply put... unsigned integers can be twice as high as signed integers, but unsigned integers can not have negative values.
Thus, a normal signed integer has the range:
2147483647While and unsigned normal integer has the range:
4294967295It has to do with how they …
All 9 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.