mysql Insert from left join where field match

Question

I am trying to insert values from table2 to table1 where addressB matches addressA. My attempt so far is the code below. The query seems to insert new blank records to the table1 instead what I want it to do. Can someone please tell me if this query is correct?

INSERT INTO database1.table1 (name)
select database2.table2.distName
from database2.table2
left join database1.table1
On database2.table2.addressB = database1.table1.addressA
where database2.table2.addressB = database1.table1.addressA

My sql fiddle

http://sqlfiddle.com/#!9/aca3e/2

Answer 1

INSERT INTO database1.table1 (name)
select database2.table2.a_distName2
from database2.table2
left join database1.table1
On database2.table2.addressB = database1.table1.addressA
where database1.table1.addressA is null;

Answer 2

After the sql fiddle I'm even more convinced that you need to use update and not insert.

update table1 inner join table2 on table1.addressA=table2.addressB
set table1.distname=table2.distname

The null values in the table1.id columns after your insert are the result of lacking a primary key on table1.id and lacking of the auto_increment specification on the same column.

Answer 3

INSERT INTO database1.table1 (name)
select database2.table2.a_distName2
from database2.table2
inner join database1.table1
On database2.table2.addressB = database1.table1.addressA