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

    Join Date
    Oct 2012
    Posts
    35
    Rep Power
    2

    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.

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

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,030
    Rep Power
    4210
    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
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo