Hi the data is in the text format, the data are separated by , (comma) and
are enclosed by " (double quotes).
My requirement is the file resides on Client machine say A and the Database
server is on machine say B.
I execute the query from the client machine (A) the query is
LOAD DATA LOCAL INFILE '/usr/local/test.txt' into table Test fields
terminated by ',' enclosed by ' " ' lines terminated by '\r\n'
The table Test is on machine B , with the above query the data from the
Local text file (test.txt) should be inserted in the Test table of machine
B.
If you want more explanation I will provide,
Thanks
Rahul T
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 04, 2002 12:31 PM
To: [EMAIL PROTECTED]
Subject: [ILUG-BOM] Re: (no subject)
>Rahul Torvi writes:
> Can I insert the data in database that is residing on remote server using
> LOADDATA IN FILE query ?
what exactely u want to do ?
data on remote server means in which format?
is it a text file?
or do ya want to connect to the remote machine and insert the data in text
file to the database on same server?
elaborate please
regards,
ranjeet walunj
_______________________________________________
Meeting on 6th 4pm at IIT Mumbai. See http://www.ilug-bom.org.in/meet/
http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
_______________________________________________
Meeting on 6th 4pm at IIT Mumbai. See http://www.ilug-bom.org.in/meet/
http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
