SEO

#1 (**permalink**) 02-28-2008, 10:05 AM

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

#2 (**permalink**) 02-28-2008, 10:05 AM

Josselin wrote:
> 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
>

Maybe

UPDATE users SET login = email;

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

#3 (**permalink**) 02-28-2008, 10:06 AM

On 2007-06-23 13:36:38 +0200, Jerry Stuckle <jstucklex@attglobal.net> said:

> Josselin wrote:
>> 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
>>
>
> Maybe
>
> UPDATE users SET login = email;

thanks a lot ! that's it ...

joss

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

modify manually the content of a column