Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQL Error 1263

sgoldberg61's profile image sgoldberg61 posted 4 weeks 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 4 weeks ago Permalink

Is that perhaps MS SQL, not MySQL?

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.