You have carriage returns in your data file.
Try adding a 'terminated by' to your load data.
compo guy wrote:
> I am using MySQL version 3.23.11-alpha on Win98. I have created a
> database with a table borrower whose description is as follow:
>
> mysql> describe borrower;
> +---+--
I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql> describe borrower;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+--
