Re: fields data copying

From: Dave Cowden <cowden_at_earthlink.net>
Date: Mon, 03 May 1999 16:58:21 -0400
Message-ID: <372E0DED.20FD@earthlink.net>

I'm not sure if I understand your question correctly, but you might see if this helps:

INSERT INTO NAMES ( Age, Group, sex, town, Tel, email ) ( SELECT 26, group, sex, town, tel, email FROM names
WHERE email = 'xxxx_at_222.com' );

HTH
Dave

ferme_at_my-dejanews.com wrote:
>
> Does someone knows what is the simplest sql command that enable you to copy
> data from one field to another field that is not create
>
> example in the table NAMES
> to be able to copy the info of those field
>
> field Age = 25
> field Group = term
> field sex = M
> field town = Weston
> field Tel = 256-4589
> field email = xxxx_at_222.com
>
> into another field but the difference is only the Age.
> and the data is the same as the one above.
>
> field Age = 26
> field Group = term
> field sex = M
> field town = Weston
> field Tel = 256-4589
> field email = xxxx_at_222.com
>
> thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon May 03 1999 - 15:58:21 CDT