title: What does INT(1) stand for in MySQL?
body: <p><code>INT(1)</code> - I know, 1 does not mean 1 digit, it represents client output display format only.</p>
  
  <p>but what does this signify </p>
  
  <p>i have declared <code>YEAR</code> as <code>int(1)</code>, I still see all 4 bytes. please tell me what does <code>INT(1)</code> means ?</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM TEST_USERDB;
  </code></pre>
  
  <pre class="lang-none prettyprint-override"><code>+----+--------+------+
  | ID | NAME   | YEAR |
  +----+--------+------+
  |  1 | abcccc | 2012 |
  |  2 | stack  |   99 |
  +----+--------+------+
  </code></pre>