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