Green,
Actaully i am dumping that data from oracle into .lst
file which will be in the mysql format. We are not getting any \n\r in
that case.
Thanks,
Narasimha
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 10:55 PM
To: Lakshmi NarasimhaRao (WT01 - Voice & Next Generation Networks)
Cc: mysql@lists.mysql.com
Subject: RE: Reg insertion of data
That's not dumping. That is loading. Dumping is when you put the data
INTO a file.
Does your source data contain the \r\n pair or not?
You seem to be using the default import parameters as you are not
specifying any values that could apply specifically to your data. Please
RTFM for LOAD DATA INFILE for options and specifics:
http://dev.mysql.com/doc/mysql/en/load-data.html.
There is a note on that page that specifically covers importing from
Windows files.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
<[EMAIL PROTECTED]> wrote on 10/04/2005 12:59:41 PM:
>
> Green,
>
>
> Thank you very much for your reply. Yes, if i see in the
> hex(), 0D 0A are coming at the end of each line.
> While dumping data i am using just
>
> LOAD DATA INFILE My.LST' INTO TABLE My_Table;
>
>
>
> Please let me know what deleimiters i have to use to avoid '\n\r' at
teh
> end of line.
>
>
> Thanks,
> Narasimha
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>
> Sent: Tuesday, October 04, 2005 10:23 PM
> To: Lakshmi NarasimhaRao (WT01 - Voice & Next Generation Networks)
> Cc: mysql@lists.mysql.com
> Subject: RE: Reg insertion of data
>
>
>
> You also forgot to mention how you are dumping....
>
>
> Do you see the trailing \r if you run a normal query on the field? Use
> the HEX() function and look for the value 0D anywhere in the output.
>
>
> Are you 100% certain that the \r is not part of your original data?
If
> you look at your source data with a hex editor, do you see 0D 0A at
the
> end of each line or just 0A?
>
>
> If you are importing data built in Windows, your lines will proabably
> terminate with "\r\n" and not just "\n". Are you sure you configured
> your LOAD DATA INFILE to properly parse the end-of-line markers for
the
> data you are importing?
>
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
> <[EMAIL PROTECTED]> wrote on 10/04/2005 11:49:41 AM:
>
> >
>
> > Sorry, I forgot to mention theat I am inserting into mysql using
load
> > data infile.
> >
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> >
>
> > Sent: Tuesday, October 04, 2005 9:04 PM
> > To: mysql@lists.mysql.com
> > Cc: [EMAIL PROTECTED]
> > Subject: Reg insertion of data
> >
>
> >
>
> >
>
> > Hi,
> >
>
> > We are inserting the text data into mysql. But, when we see
> the
> > dump of that table, we are seeing '\r' at the end of the value of
that
> > text. Actually we are not inserting the data with '\r'. Can any one
of
> > you help me in removing that '\r', imean I donot want to see that
'\r'
> > even in the dump.
> >
>
> >
>
> > Thanks,
> > Narasimha
> >
>
> >
>
> >
>
> > Confidentiality Notice
> >
>
> >
>
> > The information contained in this electronic message and any
> attachments
> > to this message are intended for the exclusive use of the
addressee(s)
> > and may contain confidential or privileged information. If you are
not
> > the intended recipient, please notify the sender at Wipro or
> > [EMAIL PROTECTED] immediately and destroy all copies of this
message
> > and any attachments.
> >
>
> > --
> >
>
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> >
>
> >
>
> >
>
> > Confidentiality Notice
> >
>
> >
>
> > The information contained in this electronic message and any
>
> > attachments to this message are intended
> > for the exclusive use of the addressee(s) and may contain
>
> > confidential or privileged information. If
> > you are not the intended recipient, please notify the sender at
>
> > Wipro or [EMAIL PROTECTED] immediately
> > and destroy all copies of this message and any attachments.
>
>
>
>
>
>
> Confidentiality Notice
>
>
> The information contained in this electronic message and any
> attachments to this message are intended
> for the exclusive use of the addressee(s) and may contain
> confidential or privileged information. If
> you are not the intended recipient, please notify the sender at
> Wipro or [EMAIL PROTECTED] immediately
> and destroy all copies of this message and any attachments.
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
