title: How to store a phone number in SQL as an integer?
body: <p>In MySQL, I built a table using the following code:</p>
  
  <pre><code>BUILD TABLE user
  (
      userName char(25) NOT NULL PRIMARY KEY,
      firstName char(25) NOT NULL,
      lastName char(25) NOT NULL,
      userEmail char(25) NOT NULL,
      userPhone int(10) NOT NULL,
  );
  </code></pre>
  
  <p>And suppose I make the following command:</p>
  
  <pre><code>INSERT INTO `user`(`userName`, `firstName`, `lastName`, `userEmail`, `userPhone`) 
  VALUES ("JDoe","John","Doe","jdoe@nothing.net", 9725550145)
  </code></pre>
  
  <p>MySQL runs the command without an issue, and puts the information in the table. However, when I retrieve the information for said John Doe, his phone number comes up as 2147483647.</p>
  
  <p>In a number of the entries, I sort of noticed that if the first number of their area code is greater than 2, then they get that same number. What did I do wrong, and how can I fix this so that everyone has their respective phone number and not this seemingly random value that MySQL assigns them?</p>
  
  <p>Thank you kindly.</p>