Re: Add columns to table; insert values based on row

On Thu, 1 Nov 2018, Adrian Klaver wrote:

>> alter table stations add column start_date date;
>> alter table stations add column end_date date;
>> alter table stations add column howmany integer;
>> alter table stations add column bin_col char(8);
>> 
>> insert into stations (start_date, end_date, howmany, bin_col) values ( )
>>    select site_nbr from stations
>>      where site_nbr = ' ';

> Are you trying to add new data to existing records?

Adrian,

   I am adding four columns to an existing table that already contains four
columns.

> If so where is the new data coming from?

   I have a text file and will fill each insert statement by hand if there's
not a more efficient way to do this.

Regards,

Rich