Oops! Please disregard. I found my error.
For those that wish to know, it goes like this:
mysql > load data infile '/home/mydir/Data.txt' into table Data
->fields terminated by ';'
->optionally enclosed by '"';
Oh, how stupid I feel sometimes. ;-)
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,
Thanks in advance,
Stan Anderton
4 messages in com.mysql.lists.mysqlRe: load data infile question
