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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]