Greetings!
I am having syntax difficulty with importing data into my database. I
am hoping someone can point out my error.
The command:
mysql> load data infile '/home/mydir/Data.txt' into table Data
->fields terminated by ';'
->fields optionally enclosed by ";
When I give the command as above, I get another -> line instead of
completion.
If I use '"' I get a parse error.
What should I use. In the docs I see both of the above used in the
examples.
If I don't use any 'fields optionally enclosed by' at all, then my
varchar fields are imported with quotes around them which messes up my
queries.
Suggestions please,
4 messages in com.mysql.lists.mysqlload data infile question
