var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Best approach to update field information from one database to another.
In my application, we have to work with 2 databases.
1. First database(D1) is where we get all the updated information.
like userID, emailID, status, dept etc. lets call table "ABC", which can contain more than 4 Lakhs record.
2. Second database(D2) is where we need to update to the table "XYZ" by retrieving data from D1."ABC". Table "XYZ" can contain "25 to 50 thousand records".
Now, I need to update status information in table D2."XYZ" by retrieving status field data from table D1."ABC" using "userID" as primary and foreign key.
May I know the best approach to update the status information of 50,000 records of database (D2) from 4 Lakhs records of database (D2)?
I think the best would be to use an UPDATE statement.
Originally Posted by Chinnu55