Graham Little <[EMAIL PROTECTED]> wrote: > > I am currently trying to run the following command: > > LOAD DATA INFILE "D:\mysql\sql\CountryData.txt" > INTO TABLE cou > FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\r\n' > (id, country); > > Example data in file is: > > country, id > AFGHANISTAN,4 > ALBANIA,8 > ALGERIA,12 > AMERICAN SAMOA,16 > ANDORRA,20 > ANGOLA,24 > > The table the data is being inserted into is: > > +----------+---------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------+---------+------+-----+---------+-------+ > | cou_id | int(11) | | PRI | 0 | | > | cou_name | text | | | | | > +----------+---------+------+-----+---------+-------+ > > I am getting the following error message and i am not > sure why? > > Error 1054: Unknown column 'id' in 'field list' > >
There is no column 'id' in the table cou. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
