Welcome to WebmasterWorld Guest from 54.234.38.8

Forum Moderators: open

Message Too Old, No Replies

MySQL make '' insert 0 into decimal columns by default

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

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:June 10, 2008
posts: 1130
votes: 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
12:04 am on Aug 21, 2012 (gmt 0)

Moderator from GB 

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

joined:Jan 30, 2002
posts:4842
votes: 1


perhaps the linux version had an auto-increment, and because it's a primary key a standard insert is failing.
1:36 pm on Aug 21, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:June 10, 2008
posts: 1130
votes: 0


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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members