In the last episode (Feb 06), Michael Boudreau said:
> Here's something weird: text strings containing newlines seem to have a
> backslash character added when the data is exported from the database.
> (MySQL 3.23.37 on Solaris--yes we're upgrading to .54)
>
> However, when I read the data out t
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
Here's something weird: text strings containing newlines seem to have a
backslash character added when the data is exported from the database.
(MySQL 3.23.37 on Solaris--yes we're upgrading to .54)
I entered the string "123\n456" (the "\n" is a newline, octal 012) into
a column defined as "text