1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Rep Power

    INSERTing unspecified fields on my new server

    I just moved my DB to a new server and upgraded to the latest version on MySQL.

    On my old server config (hosted by others) if I inserted a record without specifying all columns, it would enter a null or blank value for the unspecified columns.

    On the new server, I get an error for each unspecified column.

    Since the table and column attributes have not changed, I believe this a global setting that needs to be modified on the new setup.

    Any help would be appreciated.

  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Toronto Canada
    Rep Power
    Originally Posted by karnival800
    Since the table and column attributes have not changed...
    confirm this by doing a SHOW CREATE TABLE for the same table on both servers
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo