Vernon,
> I'm using the:
> LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
> which works just fine. Only problem is the date column
> which is formatted as such "4/11/1970" comes out as "-
> 00-
> 00"
>
> The date field is setup as Field: "s_date", Type: "date",
> Null, "YES", Ke
I'm using the:
LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
which works just fine. Only problem is the date column
which is formatted as such "4/11/1970" comes out as "-
00-
00"
The date field is setup as Field: "s_date", Type: "date",
Null, "YES", Key: BLANK, Default: "Nul
