Professional Web Applications Themes

modify manually the content of a column - MySQL

in my table 'users', the column 'email' exists already I created a new colum 'login' and I would like to COPY the content of the email column INTO the login column for all existing users.... is it possible to do it in a console or should I write a piece of code to do it ? thanks for your advice joss...

  1. #1

    Default modify manually the content of a column

    in my table 'users', the column 'email' exists already

    I created a new colum 'login' and I would like to COPY the content of
    the email column INTO the login column for all existing users....

    is it possible to do it in a console or should I write a piece of code
    to do it ?

    thanks for your advice

    joss

    Josselin Guest

  2. #2

    Default Re: modify manually the content of a column

    Josselin wrote: 

    Maybe

    UPDATE users SET login = email;

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: modify manually the content of a column

    On 2007-06-23 13:36:38 +0200, Jerry Stuckle <net> said:
     
    >
    > Maybe
    >
    > UPDATE users SET login = email;[/ref]

    thanks a lot ! that's it ...

    joss

    Josselin Guest

Similar Threads

  1. Is there an easy way to just modify text content with VB
    By Vicente_Vega@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 4
    Last Post: February 23rd, 05:49 PM
  2. manually created template column databind
    By David in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 22nd, 10:10 PM
  3. Replies: 8
    Last Post: September 10th, 06: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