That is brilliant thank you. I was doing it the wrong way around when i was naming the fields.
Thank you for your help graham -----Original Message----- From: Tobias Asplund [mailto:[EMAIL PROTECTED] Sent: 15 December 2003 14:46 To: Graham Little Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE.. On Mon, 15 Dec 2003, Graham Little wrote: doing selective quoting below. > LOAD DATA INFILE "D:\mysql\sql\CountryData.txt" > INTO TABLE cou (id, country); See how you try to load from a file into the columns id and country in the cou table? > The table the data is being inserted into is: > > +----------+---------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------+---------+------+-----+---------+-------+ > | cou_id | int(11) | | PRI | 0 | | > | cou_name | text | | | | | > +----------+---------+------+-----+---------+-------+ > And those columns doesn't exist. > I am getting the following error message and i am not > sure why? > > Error 1054: Unknown column 'id' in 'field list' > > > Any help would be appreciated. Hope that helps. ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]