View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:54 AM
Luuk
 
Posts: n/a
Default Re: Duplicate collum.


"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 ;-)



Reply With Quote