Home > Computers > Databases > SQL > SqlCopyColumn | About

UPDATE db1.table1 JOIN db2.table2
ON db1.table1.field = db2.table2.field
SET db1.table1.field = db2.table2.field

Concrete example : I am reinstalling a mail server and I need passwords from the old, clumsy, ISPConfig install to copy to my new, small, neat table :

mysql> 
UPDATE users JOIN dbispconfig.mail_user 
ON     users.email = dbispconfig.mail_user.email 
SET    users.password = dbispconfig.mail_user.password
;
Query OK, 21 rows affected (0.05 sec)
Rows matched: 442  Changed: 21  Warnings: 0
mysql> 

---

contact : @ychaouche yacinechaouche at yahoocom