Transfer data from one table to another in different DB connected under different user
Posted by:
Jack jjj
Date: February 12, 2009 01:25AM
Im using VB.Net and MySQl 5.0 . I have two database each having a lookuptable in it
I m login into each database as different user and both database resides in the same server. During a particular operation I need to get the data from 'lookuptable'
in the First DB to 'lookuptable' in the Second DB. Currently I was using looping in the VB.Net part but its taking long time to complete as the data is 2-3lakh. Could anybody please help how to resolve this issue using a "Insert into select query" in MySQl , but please remember The DB are different and the users to connect to db are also diferent.
Please help
Subject
Views
Written By
Posted
Transfer data from one table to another in different DB connected under different user
5502
February 12, 2009 01:25AM
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.