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

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

User, date Message
Written by jkauffman28
4 months ago
Category: Import/Export
1 posts since Wed, 09 Apr 14
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?
Written by ansgar
4 months ago
4940 posts since Fri, 07 Apr 06
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.