On 6 Feb 2003, at 8:58, Michael Boudreau wrote:
> mysql> select review into outfile '/tmp/MS55038rev1.txt' from
> MsReviews where
> msid=55038 and msreviewid=1;
> Query OK, 1 row affected (0.00 sec)
> mysql> quit
> Bye
>
> The newline seems to have had a "\" (backslash, octal 134) inserted
> before it:
>
> mss (mrb)% more /tmp/MS55038rev1.txt
> 123\
> 456
That's normal. If you don't specify any output options, the end of
each record is marked with a newline, and backslash is used as the
escape character to mark any newlines that are actually part of the
data. It's explained in the documentation, mainly in the LOAD DATA
section:
http://www.mysql.com/doc/en/SELECT.html
http://www.mysql.com/doc/en/LOAD_DATA.html
Without the backslashes, how will you know where the record ends?
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
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
