Hi, I have two databases A and B. Database B is replica of A. Database A has a table tab1(id,name,address). Database B has a table tab2(id,name,address) but tab2(address) in database B is null. How to insert data from database A tab1(address) into database B tab2(address). name and address data can be irrelevant. There is no need to have a specific address for specific name, Just need to insert data into the address column. Thanks in advance
If there's no keys to relate the two tables, then there's no way to guarantee what data you're going to get. However, you can just write an INSERT... SELECT statement to move the data between the databases.