var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: loading table with .txt file wont work
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!
This sequence has worked for me:
LOAD DATA LOCAL INFILE file.txt
INTO TABLE contacts
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
YES! that was the problem!
The part '(name,pwd)' needed to go at the end of the string (like your example)