HI all,

i'm trying to load a textfile into a tabel (called login) with this sql-string:

load data local infile 'C:\\login.txt' into table login(login,pwd) LINES TERMINATED BY '\r\n';

But all i get is an error saying that i have a typo in my SQL string.

Weird thing is that when i remove the ' (login,pwd) part, it WILL read it, but then the tables are all wrong (coz i also have an autoincrement in first column)

Any tips please?!

Thanks in advance!
Remvs

remvs,

This sequence has worked for me:

LOAD DATA LOCAL INFILE file.txt
INTO TABLE contacts
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(name,address,city,state,zip,phone);

Good luck,

Andy

Andy,

YES! that was the problem!
The part '(name,pwd)' needed to go at the end of the string (like your example)

Thanks alot!!
Remvs