comparing two mysql tables

comparing two mysql tables

am 22.06.2006 02:43:42 von dejan

Hy

Plz help me.
I have two identical mysql tables. I nead to compare it and update the
diferences.

table1
id name surname zauzetost
--------------------------
1 John Doe 0
2 Jane Doe 1
3 Mike Dean 0


table2
id name surname zauzetost
--------------------------
1 John Doe 0
2 Jane Doe 0


Ok, in table 1 i have 'zauzetost' with it's values, now script neads to
compare its values and if found diference update table2 with table1 values.

In this case: Jane Doe from table1 'zauzetost' value is 1, in table2 is 0.
Its diferent so script neads to update table2 'zauzetost' value for Jane Doe
into 1.

Not very complicated, buth i dont know how to make it.
Tnx in advance for your brain cells.
Dejan