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 2 years 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 2 years ago
I think Heidi inserts NULLs for values which have a "NULL" string in it. But only for the "Client parses file contents" method.
nobswolf posted 12 months ago
Maybe an option for what to replace to NULL would be a nice idea like this:

==options==

[ ] create NULL from string ______

ansgar posted 12 months ago
Are we talking about the LOAD DATA command (server parsing) or the client parsing method in the import dialog?
nobswolf posted 12 months ago
From a user's perspective I'd say this should be transparent.

So this feature should be possible in both technics. How this is implemented on the SQL level is a different topic of course.

ansgar posted 12 months ago
How to insert NULL's from certain strings in the LOAD DATA command?
nobswolf posted 12 months ago
I will look into it... I think it is possible with some of the "escape"-parameters... It's been a while since I was into that low level console stuff :)

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