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
