02-28-2008, 07:54 AM
|
| |
 Re: Duplicate collum.
tsk, tsk, tsk
Luuk wrote:
> "strawberry" <zac.carey@gmail.com> schreef in bericht
> news:1152111691.332507.74280@p79g2000cwp.googlegro ups.com...
> > Yes
> >
> > See http://dev.mysql.com/doc/refman/5.0/en/update.html for the syntax
> >
> > Kasper K wrote:
> >> Hey NG!
> >>
> >> I have a table like this:
> >>
> >> +-----+----------+----------+
> >> | id | value_uk | value_dk |
> >> +-----+----------+----------+
> >> | 1 | hello | (null) |
> >> +-----+----------+----------+
> >> 1 row in set
> >>
> >> can i duplicate the value_uk collum so it throws all the values into
> >> value_dk collum, ofcourse in same id row?
> >>
> >>
> >> Regards,
> >> Kasper K.
> >
>
> so, probably something like:
> UPDATE your_table_name SET value_dk=value_uk;
>
> but i hope you verify this by reading the manual ;-) |