Copy column contents

Поиск
Список
Период
Сортировка
Искать

Copy column contents

От:
arun kv <arun@library.iisc.ernet.in>
Дата:
hai,
       I have a database table with 8 fields and i want to add a new
column and copy the contents of one column to new column. if i try using
select and insert number of rows is duplicating and insertion is going to
end. how do i insert that contents to same row.

i am getting something like :

title | id | web | email | name
 aaa | 11 | | |
 bbb | 22 | | |
 ccc | | | |
     |    |     |     |aaa|
     |    |     |     |bbb|
     |    |     |     |ccc|


but i want as

title | id | web | email | name
 aaa | 11 | | |aaa|
 bbb | 22 | | |bbb|
 ccc | | | |ccc|


pls can anyone help me how do i go about this updation.


thanks
          Arun

Re: Copy column contents

От:
Chris <csmith@squiz.net>
Дата:
Hi,

>        I have a database table with 8 fields and i want to add a new
>column and copy the contents of one column to new column. if i try using
>select and insert number of rows is duplicating and insertion is going to
>end. how do i insert that contents to same row.

Almost right, use update instead of insert:

UPDATE table SET name = title;

HTH,
Chris.

Re: Copy column contents

От:
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Дата:
UPDATE table SET email = title;

Chris

> -----Original Message-----
> From: pgsql-php-owner@postgresql.org
> [mailto:pgsql-php-owner@postgresql.org]On Behalf Of arun kv
> Sent: Wednesday, 24 July 2002 1:59 PM
> To: PGSQL
> Subject: [PHP] Copy column contents
> 
> 
> hai,
>        I have a database table with 8 fields and i want to add a new
> column and copy the contents of one column to new column. if i try using
> select and insert number of rows is duplicating and insertion is going to
> end. how do i insert that contents to same row.
> 
> i am getting something like :
> 
> title | id | web | email | name
>  aaa | 11 | | |
>  bbb | 22 | | |
>  ccc | | | |
>      |    |     |     |aaa|
>      |    |     |     |bbb|
>      |    |     |     |ccc|
> 
> 
> but i want as
> 
> title | id | web | email | name
>  aaa | 11 | | |aaa|
>  bbb | 22 | | |bbb|
>  ccc | | | |ccc|
> 
> 
> pls can anyone help me how do i go about this updation.
> 
> 
> thanks
>           Arun
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

FAQ