In article <[EMAIL PROTECTED]>,
"Barbara Deaton" <[EMAIL PROTECTED]> writes:
> Thank you for the idea. It fixed my date problem, but my numeric column is
> still 0 and NOT "NULL." Here's what I did:
> create table a (
> d date default null,
> e smallint default null );
> CREATE TEMPO
Fuchs
Sent: Saturday, November 05, 2005 10:03 AM
To: mysql@lists.mysql.com
Subject: Re: Problem with load data and NULL
In article <[EMAIL PROTECTED]>,
"Barbara Deaton" <[EMAIL PROTECTED]> writes:
> All,
> I need help with using load data to load a text file that is crea
In article <[EMAIL PROTECTED]>,
"Barbara Deaton" <[EMAIL PROTECTED]> writes:
> All,
> I need help with using load data to load a text file that is created by
> another application.
> I have a text file that contains 2 columns, date and smallint and 2 rows:
> d,e
> 2005-12-31,
> ,2
> In the abo
All,
I need help with using load data to load a text file that is created by another
application.
I have a text file that contains 2 columns, date and smallint and 2 rows:
d,e
2005-12-31,
,2
In the above example the first row, column e should be NULL and the second row
column d should be NULL