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
