Menu
I have a table whose create statement is:
CREATE TABLE `takas` (
`TAKAS_NO` bigint(20) NOT NULL,
`FIYAT` decimal(20,2) NOT NULL,
`MIKTAR` decimal(20,5) NOT NULL)
...
is TAKAS_NO a signed bigint or unsigned? I couldn't find the answer in web.
904
A large integer. The signed range is -9223372036854775808 to 9223372036854775807 . The unsigned range is 0 to 18446744073709551615 . SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE .
UNSIGNED only stores positive numbers (or zero). On the other hand, signed can store negative numbers (i.e., may have a negative sign). UNSIGNED ranges from 0 to n , while signed ranges from about -n/2 to n/2 . In this case, you have an AUTO_INCREMENT ID column, so you would not have negatives.
The “unsigned” in MySQL is a data type. Whenever we write an unsigned to any column that means you cannot insert negative numbers. Suppose, for a very large number you can use unsigned type. The maximum range with unsigned int is 4294967295. Note: If you insert negative value you will get a MySQL error.
The number is used to display width. BIGINT takes 8 bytes i.e. 64 bits. The signed range is -9223372036854775808 to 9223372036854775807 and unsigned range takes positive value. The range of unsigned is 0 to 18446744073709551615.
All ints are signed unless you specify that they're unsigned:
CREATE TABLE foo (
x int // signed
y int unsigned // unsigned
);
The answer is yes. All ints are signed
for detail see this link http://ronaldbradford.com/blog/bigint-v-int-is-there-a-big-deal-2008-07-18/
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
