I have a problem on comparing data.
I have two databases that have a similar (if not same) tables, but holds different data, and I want to merge the two tables. But can't seem to figure the easy way to do that, again and again I use script (PHP) to do that, which is take a long time.
The tables which I mentioned is like this, I have two databases, A and B, stored in different server, in each of the databases, I have table called t, so it will be like A.t and B.t. The t table holds schema like
id, username, email, password.
Are there any ways to do that within database level?
Any guidance is truly appreciated, please enlightened me :D
Thanks in advance.