>>>> 2012/03/27 12:33 +0200, Johan De Meersman >>>>
MySQL does have a proper CSV engine; and it's mystifying why it isnt' accessible in any
other way. I say "engine", and you can take that literally: just like you have MyISAM and
InnoDB engines, CSV is also an engine that is applicable to tables.
Yes, I looked into it, but NULL is a problem, and its being in the data directory another
one. The latest version requires NOT NULL for all fields, and that is too much for me. I
believ an earlier version allowed NULL, but that, too, "escaped" it with the word NULL, as
happens if with INTO OUTFILE one also sets FIELDS ESCAPED BY ''. Furthermore, field names
are needed for my use.
CSV reallie is useful, with its simple quoting mechanism. The one extension to allow for
NULL I deem best is that there be nothing between separators for NULL, and a pair of
double-quotes for an empty string.