Illogical SQL out of range value for integer column
<p>I am getting an odd SQL error. I have a table client which contains the following attributes:</p>

<ul>
<li>ClientID </li>
<li>Title</li>
<li>Name</li>
<li>LastName</li>
<li>Email</li>
<li>Cellphone</li>
<li>Points</li>
<li>Balance</li>
</ul>

<p>Points is set up as an integer of length 11 with NULL values accepted</p>

<p>I try to insert a new client using the following code:</p>

<pre><code>INSERT into client VALUES (154,"Mr","Ted","Jones","td@gmail.com","07951234567",0,0);
</code></pre>

<p>And I get the following error:</p>

<blockquote>
  <p>1264 - Out of range value for column 'Points' at row 1</p>
</blockquote>

<p>Just in case it is needed, the data in the first row is:</p>

<pre><code>111 Mr  Rob Taylor  rt@hotmail.com  07523363535 438 0
</code></pre>

<p>I am finding it hard to understand what the error is about. It's not as if points will ever get to be so large that it needs to become a BigInt. </p>

<pre><code>CREATE TABLE client ( 
    ClientID int(11) NOT NULL, 
    Title varchar(45) NOT NULL, 
    Name varchar(45) NOT NULL, 
    LastName varchar(45) NOT NULL, 
    Email varchar(45) NOT NULL,
    Cellphone bigint(11) DEFAULT NULL, 
    Points int(11) DEFAULT NULL, 
    Balance decimal(10,0) NOT NULL 
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8; 
</code></pre>