Professional Web Applications Themes

Duplicate collum. - MySQL

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

  1. #1

    Default 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.
    Kasper K Guest

  2. #2

    Default Re: Duplicate collum.

    Yes

    See [url]http://dev.mysql.com/doc/refman/5.0/en/update.html[/url] 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.
    strawberry Guest

  3. #3

    Default Re: Duplicate collum.


    "strawberry" <zac.carey> schreef in bericht
    news:1152111691.332507.74280p79g2000cwp.googlegro ups.com...
    > Yes
    >
    > See [url]http://dev.mysql.com/doc/refman/5.0/en/update.html[/url] 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 ;-)



    Luuk Guest

  4. #4

    Default Re: Duplicate collum.

    tsk, tsk, tsk

    Luuk wrote:
    > "strawberry" <zac.carey> schreef in bericht
    > news:1152111691.332507.74280p79g2000cwp.googlegro ups.com...
    > > Yes
    > >
    > > See [url]http://dev.mysql.com/doc/refman/5.0/en/update.html[/url] 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 ;-)
    strawberry Guest

Similar Threads

  1. Duplicate IP's and AOL
    By Joe_Krako in forum Macromedia ColdFusion
    Replies: 2
    Last Post: May 24th, 01:24 PM
  2. Can't see new collum from my data grid
    By Taly in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: July 29th, 08:55 AM
  3. duplicate a w3d
    By Jimmy in forum Macromedia Director 3D
    Replies: 4
    Last Post: October 28th, 10:41 PM
  4. Duplicate Namespaces
    By Garret in forum ASP.NET Web Services
    Replies: 0
    Last Post: August 25th, 12:51 PM
  5. duplicate this!
    By michael in forum Microsoft Access
    Replies: 3
    Last Post: July 17th, 03:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139