Re: Question regarding INSERT
From: Stein-Tore Erdal <erdal_at_telepost.no>
Date: 1995/07/30
Message-ID: <3vg9mc$7re_at_nms.telepost.no>#1/1
Date: 1995/07/30
Message-ID: <3vg9mc$7re_at_nms.telepost.no>#1/1
n0a7367_at_vms2.tamu.edu (Nagendra Annadanam) wrote:
>I have a table with existing data. If I add a new column, is it
>possible to insert data into the column directly without referencing
>to the primary key or other column data ?
If the data to be "inserted" in the column is the same for all rows:
update your_table
set new_column = same_data;
Cheers
Stein-Tore Erdal
erdal_at_telepost.no
Received on Sun Jul 30 1995 - 00:00:00 CEST