Problem with LOAD LOCAL DATA INFILE

2002-08-21 Thread compo guy
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 |

Re: Problem with LOAD LOCAL DATA INFILE

2002-08-21 Thread Gerald Clark
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;