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
n time.
Regards,
Dominic
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2002 15:12
To: [EMAIL PROTECTED]
Subject: Re: NULL Values in mysqldump
On 27 Feb 2002, at 8:18, Baines, Dominic wrote:
> If you immediately use the dump, this is fine if it is to b
On 27 Feb 2002, at 8:18, Baines, Dominic wrote:
> If you immediately use the dump, this is fine if it is to be used
> with MySQL but if you want to port it to another RDBMS the /N for
> a NULL causes some 'issues'.
If you don't care about the difference between NULL and the empty
string or 0, w
This is probably an easy one for someone...
Is here an easy way NOT to have a mysqldump data file that includes /N when the column
is a NULL ?
Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data
file for al the NULL VALUES.
Scripting a global cut or strip out o