Php and MySql - copy data from one to another table -

i want know how if possible copy data 1 table column in same database? code below not working version of mysql should working.

update `table1` set `table1.column1` =  (select `table2.column2` table2 `table1.city` = 'table2.city')  `listing` ='5'

do have idea ? !

guys, thought solution possible php script , solution problem make short script gonna while loop :)

thanks on joining discussions !

the solution in `` marks between them should column names, works nice, enjoy !

insert database2.table1 (field1,field3,field9) select table2.field3,table2.field1,table2.field4 table2;

check mysql

Scrio