LOAD DATA INFILE..

[Graham Little]

Hi everyone,

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'


Any help would be appreciated.

Thanks

Graham 

________________________________________________________________________
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]