 | |
#1
 
| |||
| |||
|
mysql column type -
12-02-2011
, 07:53 PM
#2
| |||
| |||
|
|
hi,guys. I want ask a question, if i set a column type int(64), can it insert into a 64 bits number ? thanks |
tells you want you need to know.
INT is a 64 bit entity.
#3
| |||
| |||
|
|
In article b5e450c9-2f4f-45c4-b189-43a571766... (AT) q30g2000yqj (DOT) googlegroups.com>, john <linxiuzhang2... (AT) gmail (DOT) com> wrote: hi,guys. I want ask a question, if i set a column type int(64), can it insert into a 64 bits number ? thanks I don't think you have the ability to specify the 'type' used to store a number through SQL. I think that's an implementation of the database. This says to use BIGINT rather than INT: http://dev.mysql.com/doc/refman/4.1/...ric-types.html -- DeeDee, don't press that button! DeeDee! NO! Dee... [I filter all Goggle Groups posts, so any reply may be automatically ignored] thanks for telling me . i see somebody set a column type is int(64) , i don not understand what is the meaning, does int max length is 11 ? |
#4
| |||
| |||
|
|
john wrote: * *hi,guys. I want ask a question, if i set a column type int(64), can it insert into a 64 bits number ? thanks http://dev.mysql.com/doc/refman/5.1/...ger-types.html tells you want you need to know. INT is a 64 bit entity. i want to khow what 64 is meaning ? |
#5
| |||
| |||
|
|
On 12鏈3鏃, 涓嬪崍12鏃13鍒, The Natural Philosopher <t... (AT) invalid (DOT) invalid wrote: john wrote: hi,guys. I want ask a question, if i set a column type int(64), can it insert into a 64 bits number ? thanks http://dev.mysql.com/doc/refman/5.1/...ger-types.html tells you want you need to know. INT is a 64 bit entity. i want to khow what 64 is meaning ? Its one less than 65? |
#6
| |||
| |||
|
|
On 12月3日, 下午3时29分, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote: In article b5e450c9-2f4f-45c4-b189-43a571766... (AT) q30g2000yqj (DOT) googlegroups.com>, john <linxiuzhang2... (AT) gmail (DOT) com> wrote: hi,guys. I want ask a question, if i set a column type int(64), can it insert into a 64 bits number ? thanks I don't think you have the ability to specify the 'type' used to store a number through SQL. I think that's an implementation of the database. This says to use BIGINT rather than INT: http://dev.mysql.com/doc/refman/4.1/...ric-types.html thanks for telling me . i see somebody set a column type is int(64) , i don not understand what is the meaning, does int max length is 11 ? |
tells you all about that. The number after the data type is just a field
width, and doesn't affect the size of the data storage.
You will often find that reading the online documentation give you an
answer more quickly than waiting for a reply on a newsgroup!
The investment in time is well worth it...
Cheers
Tony
--
Tony Mountifield
Work: tony (AT) softins (DOT) co.uk - http://www.softins.co.uk
Play: tony (AT) mountifield (DOT) org - http://tony.mountifield.org
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.