MySQL Forums
Forum List  »  Docs

SELECT OUTFILE - special character problem
Posted by: Stanley Shapiro
Date: February 16, 2005 12:23PM

I am using '\n' to generate new lines to create address labels. Thus:

select '\n',
name_line_1,'\n',
address_line_1,'\n',
address_line_2,'\n'
.....
into outfile 'C:\\DATA\\ADDRLIST.txt'
from .....

The output is properly aligned, but in addition, a slash is printed at each newline position.

How can I suppress this slash ?
I am running MySQL 4.1.7 on Windows 98.

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT OUTFILE - special character problem
6998
February 16, 2005 12:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.