>>>> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
