Welcome to WebmasterWorld Guest from 54.160.131.144

Forum Moderators: open

Message Too Old, No Replies

MySQL make '' insert 0 into decimal columns by default

     

andrewsmd

10:34 pm on Aug 20, 2012 (gmt 0)

WebmasterWorld Senior Member 5+ Year Member



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

12:04 am on Aug 21, 2012 (gmt 0)

WebmasterWorld Administrator brotherhood_of_lan is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



perhaps the linux version had an auto-increment, and because it's a primary key a standard insert is failing.

andrewsmd

1:36 pm on Aug 21, 2012 (gmt 0)

WebmasterWorld Senior Member 5+ Year Member



No, the ID column auto increments fine. These are columns that hold charges.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month