Align two mysql tables

Question

I have two databases. WordpressDB and JoomlaDB

WordpressDB has table db1_users JoomlaDB has table db2_users

thoose tables has the same fields names

id  | email | Login | Password

General database is WordpressDB. So i need all id in JoomlaDB make the same as id in WordpressDB where email field is the same.

So how to do that, it is about 10.000 entries?

Answer 1

I don't know if this is right or not, but if you're looking for query to update ID in table joomla using data ID in table wordpress, I think you can use this :

update WordpressDB.tbl_user1 
set WordpressDB.tbl_user1.ID=(
select JoomlaDB.tbl_user2.ID from JoomlaDB.tbl_user2 
where JoomlaDB.tbl_user2.EMAIL=WordpressDB.tbl_user1.EMAIL
)