phparmy
asked on
smallint,mediumint,int type length?
hello,
in my table
i created columns like below
city_id smallint(11) unsigned,
user_id mediumint (11) unsigned,
message_id int (11) unsigned,
inside of parantheses what means 11 if i write something less or big.
if i created
city_id smallint(5) unsigned,
user_id mediumint (5) unsigned,
message_id int (5) unsigned,
is there will be any effect in memory or performance. Shortly what is different.
i readed in mysql site but do not understant.
in my table
i created columns like below
city_id smallint(11) unsigned,
user_id mediumint (11) unsigned,
message_id int (11) unsigned,
inside of parantheses what means 11 if i write something less or big.
if i created
city_id smallint(5) unsigned,
user_id mediumint (5) unsigned,
message_id int (5) unsigned,
is there will be any effect in memory or performance. Shortly what is different.
i readed in mysql site but do not understant.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kevin Cross
Ah, openshac linked it for you too. The text in that post is from the linked manual for MySQL. Hopefully that explains it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.