val schreef:
> 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

thats not a MOVE, thats more like a COPY...

>
> 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

an UPDATE should do it, give us what you tried, and the error message(s)
you got...

--
Luuk