Posted by Dejan on 06/22/06 00:43

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

[Back to original message]