distal-attribute
distal-attribute
distal-attribute
distal-attribute

Null value for CSV upload into a MYQL date/time field with a default of NULL

jkauffman28 posted 7 months ago in Import/Export
I'm trying to replace blanks in a datetime field in an excel csvv that is inserted in a MySQL database. I've tried all values found at http://staraphd.blogspot.com/2009/09/import-null-values-into-mysql-via.html to no avail.

What am I missing?
ansgar posted 6 months ago
I think Heidi inserts NULLs for values which have a "NULL" string in it. But only for the "Client parses file contents" method.

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