Tweet
So what is the id column now?
-
I'm building a wagon! On some other part of the internets, obviously (but not that other site). -
now it's an int(10)
should last a bit longer
Co-Founder, Apolyton Civilization Site
Co-Owner/Webmaster, Top40-Charts.com | CTO, Apogee Information Systems
giannopoulos.info: my non-mobile non-photo news & articles blogComment
-
I thought the number in parantheses is the default display length while the max number can be held is determined by type of field? So tinyint (unsigned) holds 255, smallint holds 65535, etc?(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."Comment
-
mySQL fields don't work that way. They are literally the number of digits in the number. This is fairly standard among DB implementations.Originally posted by Urban Ranger
I thought the number in parantheses is the default display length while the max number can be held is determined by type of field? So tinyint (unsigned) holds 255, smallint holds 65535, etc?“It is no use trying to 'see through' first principles. If you see through everything, then everything is transparent. But a wholly transparent world is an invisible world. To 'see through' all things is the same as not to see.”
― C.S. Lewis, The Abolition of ManComment
-
Then shouldn't int(5) be equal to 99999 instead of 65535 ?
Just wondering
Is God willing to prevent evil, but not able? Then he is not omnipotent. Is he able, but not willing? Then he is malevolent. Is he both able and willing? Then whence cometh evil? Is he neither able nor willing?
Then why call him God? - EpicurusComment
-
Yes.Originally posted by alva
Then shouldn't int(5) be equal to 99999 instead of 65535 ?
Just wondering
“It is no use trying to 'see through' first principles. If you see through everything, then everything is transparent. But a wholly transparent world is an invisible world. To 'see through' all things is the same as not to see.”
― C.S. Lewis, The Abolition of ManComment
-
Not according to MySQL (Second Edition) by Paul Dubois (Sam's 2003), pp. 102 - 104.Originally posted by pchang
mySQL fields don't work that way. They are literally the number of digits in the number. This is fairly standard among DB implementations.(\__/) 07/07/1937 - Never forget
(='.'=) "Claims demand evidence; extraordinary claims demand extraordinary evidence." -- Carl Sagan
(")_(") "Starting the fire from within."Comment
Comment