On 27 Feb 2002, at 10:31, Baines, Dominic wrote:
> However, in this case the MySQL columns values are NULL the problem
> (if it is one) is that /N does not mean NULL in other RDBMS and you have
> to craft a method of converting or parsing the data either at load or
> pre-load to another format to allow for the /N.
Are you saying that other RDBMSs do use an empty string to represent
NULL in CSV files? If so, I still don't understand how they're
supposed to know whether a NULL or an empty string is intended. If
not, it seems what you really want is a way to specify how NULL is
represented in the export. (By the way, it's actually a backslash,
not a slash, in \N.)
If you have Perl, then stripping out the \N after export is as easy
as
perl -pi.bak -e"s/\\N//g" filename
(with perhaps slight adjustments to the exact syntax depending on
your shell), and changing it to something else is just as easy. You
can do similar things with other languages. I don't think there's an
answer in MySQL itself.
[Filter fodder: SQL, query]
--
Keith C. Ivey <[EMAIL PROTECTED]>
Washington, DC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
