<div>
NOT NULL DEFAULT 0 might be helpful in that column definition.<br />
<br />

</div>


NOT NULL DEFAULT 0 might be helpful in that column definition.



<div>
It was not a problem any more once I ensure that field have no null value.
</div>


It was not a problem any more once I ensure that field have no null value.

<div>
I find the solution on my own.
</div>


<div>
<div class="content wysiwyg-content">
I am getting this error when I tried to set this field (column_id, and 3 other columns) as primary key. &nbsp;Why is it complaining that it is truncated. &nbsp;column_id is set as int(10) and the max value thus far for that column is 7982. &nbsp;It is no where near 10 integers.
</div>
</div>


I am getting this error when I tried to set this field (column_id, and 3 other columns) as primary key.  Why is it complaining that it is truncated.  column_id is set as int(10) and the max value thus far for that column is 7982.  It is no where near 10 integers.

SQL error 1265 DAta truncated for column 'column_id' at row 655

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.