SELECT OUTFILE - special character problem
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.
Subject
Views
Written By
Posted
SELECT OUTFILE - special character problem
6998
February 16, 2005 12:23PM
3034
February 17, 2005 03:43PM
2950
July 17, 2006 08:13AM
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.