Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- MySQL make '' insert 0 into decimal columns by default


andrewsmd - 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


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4486603.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com