Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
here's the statement:
LOAD DATA LOCAL INFILE '/scripts/myfile.txt' INTO TABLE table (id,title) FIELDS TERMINATED BY ',' ENCLOSED BY '"'
Here's a sample of the actual txt file:
The database table is simply two columns: id varchar(5) and title varchar (255)
I've tried the statement both with and without the LOCAL modifier, it seems to make no difference. The error I get is
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 'FIELDS TERMINATED BY ',' ENCLOSED BY '"'' at line 1
As far as I can tell from reading the manual and about a dozen examples is that my syntax is correct. Any ideas?