php - default values for different mysql server version -

i have php project use self-made wrapper mysqli extension. works select, update , delete statements, not insert.

for example have table 3 fields - id, name, surname. insert query looks this:

$add = new sqlquery(); $add->addfield('id', 1); $add->addfield('name', 'alex'); $add->execute(); 

and fails always, because sql server has no default value surname field.
mystery reasons code works on production server.

are there differences default values setting different mysql server versions?
or, there option or parameter, how can manage such behavior mysql server?

you can either specify default value surname field or insert placeholder value yourself.

an insert statement fail on mysql side otherwise. i'm not sure why working on production servers if there's no default value specified either on opinion it's bad practice leave such holes in data anyways.

so if user didn't gave or haven't specified data should store advise choosing default placeholder - plain null value or empty strings or whatever easier work data later if have set properly.