sql - MySQL: No update statements working -

i'm trying update table of database values table , database, using common field.

however none of statements working , can't figure out why. running ten minutes (way long) , server disconnects.

first try:

update database1.table1 t1, database2.table2 t2 set t1.field1 = t2.field1 t1.field2 = t2.field2; 

second try:

update database1.table1 t1 inner join database2.table2 t2 on t1.field2 = t2.field2 set t1.field1 = t2.field1;   

can push me in right direction? where/on-conditions working in separate select statements. workaround created new tables select join, slow work.

field1 unique in table2, not table1. want update multiple entries in table1 unique value table2.