| MySQL make '' insert 0 into decimal columns by default
|
andrewsmd
msg:4486605 | 10:34 pm on Aug 20, 2012 (gmt 0) |
I'm migrating a PHP system that was running on a linux box to a windows server. I'm running into issues that wherever there is a INSERT INTO TABLE(column1) VALUES(''); it errors. On the linux box, it inserts 0, but on the windows machine it fails. How do I go about making the windows box also insert 0. Is this a possible problem from some default value not getting copied properly? I moved this MySQL database with mysqldump through PHPMyAdmin
|
brotherhood of LAN
msg:4486622 | 12:04 am on Aug 21, 2012 (gmt 0) |
perhaps the linux version had an auto-increment, and because it's a primary key a standard insert is failing.
|
andrewsmd
msg:4486766 | 1:36 pm on Aug 21, 2012 (gmt 0) |
No, the ID column auto increments fine. These are columns that hold charges.
|
|
|
