Title: Re: importing data into mysql from oracle using a text file
|
The sample lines are like this in
alarm.txt
ARRIVED DETECTED
NAME
TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
---------
--------- -------------------- --------- ---------- - --------- ------------
---------
REASON
------------------------------------------------------------
27-SEP-04 27-SEP-04
alaram
0 0
N
0
2
1
27-SEP-04 27-SEP-04
MiTel
0 0
N
0
2
2
The above lines i am not able to insert into mysql.
After changing the format as below(as in the
sample.txt) i am able to insert into mysql but not correclty. Couls you
please help me in this.
2004-09-27 \t 2004-09-27 \t alaram \t 0 \t 0 \t N \t 0 \t 2 \t 1 \n
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.
|
|
ARRIVED DETECTED NAME TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
--------- --------- -------------------- --------- ---------- - --------- ------------
---------
REASON
------------------------------------------------------------
27-SEP-04 27-SEP-04 alaram 0 0 N 0 2
1
27-SEP-04 27-SEP-04 MiTel 0 0 N 0 2
2
2004-09-27 \t 2004-09-27 \t alaram \t 0 \t 0
\t N \t 0 \t 2 \t 1 \n
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
