small problem

alx_81 · #1 (**permalink**) 02-11-04, 12:01

i'm a new user of mysql..
what does it means the brackets after int datatype??

ex:
create table table1
...
field1 int (8) <--????
int occupes 4 bytes so 8?? what's??

sorry for this "stupid question"... but i must know what's 8!!
=)))

thx!

ika · #2 (**permalink**) 02-14-04, 09:44

Quote:

Originally posted by alx_81
i'm a new user of mysql..
what does it means the brackets after int datatype??

ex:
create table table1
...
field1 int (8) <--????
int occupes 4 bytes so 8?? what's??

sorry for this "stupid question"... but i must know what's 8!!
=)))

thx!

That means maximum number you can insert is 99999999 (eight number places)

r937 · #3 (**permalink**) 02-14-04, 10:01

Quote:

Originally posted by ika
That means maximum number you can insert is 99999999 (eight number places)

no, you can still insert any integer value (up to 2 billion or whatever it is)

the 8 refers to the minimum number of digits to display when using ZEROFILL

observe:

PHP Code:


			
create table testzerofill 

( foo1 integer 

, foo2 integer(8)

, foo3 integer(8) zerofill

, foo4 integer(11) zerofill

);

insert into testzerofill 

values 

 ( 1, 1, 1, 1)

,( 999999999, 999999999, 999999999, 999999999 )

,( 11111111111, 11111111111, 11111111111, 11111111111)

;

select * from testzerofill;



   foo1       foo2       foo3       foo4  

         1          1   00000001 00000000001 

 999999999  999999999  999999999 00999999999 

2147483647 2147483647 4294967295 04294967295