<div>
&quot;But lately I saw I could use SMALLINT(1) as well for that&quot;<br />
<br />
Where did you see that? <br />
<br />
<br />
Alan<br />
<br />

</div>


"But lately I saw I could use SMALLINT(1) as well for that"

Where did you see that?


Alan



<div>
In my database... I was using values of lets say '2300', normally I would use like SMALLINT(4) for that, but lately I saw that when I use SMALLINT(1) as well...
</div>


In my database... I was using values of lets say '2300', normally I would use like SMALLINT(4) for that, but lately I saw that when I use SMALLINT(1) as well...

<div>
I will be curious to see if anyone has any insight to this as well. I am not sure of the inner workings of MySQL but some logic and some basic math skills would tell you that 2300 can't be stored in one byte. My guess would be that the '1' doesn't represent what it appears to represent.<br />
<br />
<br />
<br />
Alan 
</div>


I will be curious to see if anyone has any insight to this as well. I am not sure of the inner workings of MySQL but some logic and some basic math skills would tell you that 2300 can't be stored in one byte. My guess would be that the '1' doesn't represent what it appears to represent.



Alan

<div>
My best guess is that the 1 means like (smallint = 2 bytes), so that it would mean 2bytes x 1<br />
And then it is correct. If this is true however, then I am very stupid as all my indexes on my database are like INT(10) :-)
</div>


My best guess is that the 1 means like (smallint = 2 bytes), so that it would mean 2bytes x 1
And then it is correct. If this is true however, then I am very stupid as all my indexes on my database are like INT(10) :-)

<div>
<div class="content wysiwyg-content">
<a href="http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html" rel="ugc nofollow">http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html</a><br />
<br />
In this overview you can see for example:<br />
TINYINT = 0 - 255 (unsigned)<br />
SMALLINT = 0 - 65535 (unsigned)<br />
MEDIUMINT = 0 - 16777215 (unsigned)<br />
<br />
Now in my database (MySQL) I use for example<br />
SMALLINT(3) for numbers from 0 -&gt; 999. But lately I saw I could use SMALLINT(1) as well for that...<br />
<br />
Can someone clarify this?
</div>
</div>


http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html

In this overview you can see for example:
TINYINT = 0 - 255 (unsigned)
SMALLINT = 0 - 65535 (unsigned)
MEDIUMINT = 0 - 16777215 (unsigned)

Now in my database (MySQL) I use for example
SMALLINT(3) for numbers from 0 -> 999. But lately I saw I could use SMALLINT(1) as well for that...

Can someone clarify this?

integer-questions

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.