MySQL Forums
Forum List  »  Connector/Node.js

Strange LOAD DATA INFILE error
Posted by: Anjaan Aadmi
Date: November 18, 2006 01:30AM

I have
(1) MySQL 5.0
(2) Query Borwser 1.1.17
(2) Windows XP
(4) a tab-separated data file with 143 rows and 3 columns
(5) The table exists and has the appropriate columns.

I am trying to use the statement:
LOAD DATA INFILE 'c:/Mysql/Data/CITIES_BY_COUNTRY.dat'
INTO TABLE tgm_lov
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
(lov_type, lov_name, lov_value_1)

The statement loads 79 rows and then gives the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOAD DATA INFILE 'c:/TGM/Mysql/Data/CITIES_BY_COUNTRY.dat'
INTO TABLE tgm_lov
' at line 1

I fail to understand how this can load 79 rows and then give an error!

Can someone please help?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Strange LOAD DATA INFILE error
November 18, 2006 01:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.