<div>
Uhh, please post the CREATE TABLE script and tell us which column you're concerned about, thanks.
</div>


Uhh, please post the CREATE TABLE script and tell us which column you're concerned about, thanks.

<div>
<div class="content wysiwyg-content">
I recently learned that when attempting to input a large number into a database field that's set up to accommodate only a certain number of digits, the number that is entered is 2147483647.<br />
<br />
Is there another anomaly that occurs that results in a zero being entered into the database? I'm not talking about a zero being in the data that's being inserted. Rather, I'm talking about something that chokes the system resulting a default &quot;0&quot; being entered into the field.<br />
<br />
Thoughts?
</div>
</div>


I recently learned that when attempting to input a large number into a database field that's set up to accommodate only a certain number of digits, the number that is entered is 2147483647.

Is there another anomaly that occurs that results in a zero being entered into the database? I'm not talking about a zero being in the data that's being inserted. Rather, I'm talking about something that chokes the system resulting a default "0" being entered into the field.

Thoughts?

Zero default value in MySQL Database

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.

MySQL Server

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.