SQL Error Code 1366 Incorrect integer value at row 88163
<p>I'm trying to do the following query  </p>

<pre><code>INSERT INTO 'table_1'(column_1)  
    SELECT DISTINCT 'column 2'  
    FROM other_schema.table2;  
</code></pre>

<p>Both of those columns have their fields set to INT(255), and yet I get the following error:</p>

<p>"Error Code: 1366. Incorrect integer value: 'column2' for column 'column2' at row 88163"</p>

<p>I even went and checked the individual row, but the field is a number(5800 to be precise).</p>

<p>I did some tinkering, and it seems that if I try to limit the select, it always accuses the row immediately after the upper limit of being of an incorrect value.</p>