SQL Error 1263

sgoldberg61's profile image sgoldberg61 posted 3 years ago in Import/Export Permalink

Importing data in Mysql DB data is personfirstname = NULL personmiddleinitial = I personlastname = Null

issue is NULL is not expected in the name field

I have checked the "Allow NULL" for personfirstname, personfirstname, personlastname

I still get the error "Column set to default value; NULL supplied to NOT NULL column 'personfirstname' at row"

any ideas

1 attachment(s):
  • Heidsql
ansgar's profile image ansgar posted 3 years ago Permalink

Is that perhaps MS SQL, not MySQL?

Please login to leave a reply, or register at first.