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]
