title: What is the issue with 10 digit mobile no data in mysql?
body: <p>I made a table for storing contact record of user of my website. It also contains a 10 digit mobile no.</p>
  
  <p>Table structure is like this:</p>
  
  <pre><code>CREATE TABLE contact_user
  (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  contact INT(10)
  )
  </code></pre>
  
  <p>Now the problem is that if I insert a 10 mobile no.(e.g.9595891256) using phpmyadmin into contact field it will insert some random value and shows a warning saying "data out of column range"</p>
  
  <p>But if I insert a simple 10 digit no (e.g.4561327894) then it works well and no warning is shown.</p>
  
  <p>SO please tell me what is the issue in inserting a mobile no in this column?</p>
  
  <p>I am using mysql 5.1 on ubuntu 11.04 and also using phpmyadmin.</p>