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