At 12:38 -0500 11/6/02, Vivian Wang wrote:
I tried,
db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\\\\' lines terminated by '\\n'");
db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\\\\' lines terminated by '\n'");

both no error, but my data still shift 1 byte to left.
What do you mean by "shift 1 byte to left".  What's an example of your
input data and how it actually ends up in MySQL?


Also, I tried from mysql,
mysql>load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\\' lines terminated by '\n';
no error, but my data still shift to left.

mysql>load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n';
PAGER set to stdout
'> '
-> ;
ERROR 1083: Field separator argument is not what is expected. Check the manual
That last statement is illegal, because '\' needs to be '\\'.


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to