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 = ' ';
The table has 82 rows. Is there a more elegant way to insert data specific to a site_nbr other than 82 repetitions of the insert statement? (I suspect not, but I might be wrong and learn something valuable by asking.)
That makes no sense to me...you already have 82 rows on the table so if you insert 82 more you'll have 164 which doesn't seem like what you would want...