Zero default value in MySQL Database
Posted on 2012-09-17
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.