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
