From: Thimble Smith
Date: March 12 1999 4:55pm
Subject: Re: Importing NULL values
List-Archive: http://lists.mysql.com/mysql/83
Message-Id: <19990312095529.N28088@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Thu, Mar 11, 1999 at 07:45:30PM -0500,
garyl.cwa4.epa.gov@stripped wrote:
> and data file:
> 
>      "sally","rogers",,
>      "joe","blo",32,5.5
>      "test","",,

It'd be great if you could put \N where you need a NULL.  You
could try:

sed -e 's/,,/,\\N,/g' -e 's/,$/,\\N/' < datafile > datafile.nulls

Something like that.

Tim