Re: Problem with load data and NULL

2005-11-08 Thread Harald Fuchs
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

RE: Re: Problem with load data and NULL

2005-11-08 Thread Barbara Deaton
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

Re: Problem with load data and NULL

2005-11-05 Thread Harald Fuchs
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

Problem with load data and NULL

2005-11-04 Thread Barbara Deaton
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