SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:54 AM
| ||||
| ||||
 Duplicate collum. 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.      |
|
02-28-2008, 07:54 AM
| |||
| |||
| Re: Duplicate collum. 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. |
|
02-28-2008, 07:54 AM
| |||
| |||
| 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 ;-) |
|
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 ;-) |
Linear Mode
