Hello,

Hi have a mysql data base like this

key field1 field2 field3
--------------------------------------
name1 value1 value2 value3
name2 value4 value5 value6
name3

and I would like to move data from line 1 to line 3 to have :

key field1 field2 field3
---------------------------------------
name1 value1 value2 value3
name2 value4 value5 value6
name3 value1 value2 value3

so, given name1 and name2 I want to fill the name2 row with value from
name1 row...

I have tried with UPDATE but after a couple of hours I have to admit
that I'm not able to do it :-(

Can anybody help me ?

val