What is the “Length/Values” field in phpmyadmin?

I’m trying to create a table in a mySQL table using phpmyadmin, but am really confused.

What is the Length/Values field? If I have a data type of INT, and I put the number "2" in the Length/Values field, does that mean:

Case 1: The maximum number that can be in that column is 2 (e.g. it can be 0,1,2).

Case 2: The number can have to characters (e.g. it can be 0-99)

Case 3: This is a power of two, 2^2 = 4 and that is the highest number that can be in the table.

Obviously I am totally confused and no matter how many websites I read I can’t seem to understand this field.

I would appreciate any clarification you might be able to give!!

View full post on Tycoon Talk

, ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Get Adobe Flash playerPlugin by wpburn.com wordpress themes


RSS Site FeedRSS Site Feed

© 1992-2011 DC2NET™, Inc. All Rights Reserved