Re: Copying seasonprices to next year

[Peter Brawley]

Not a database.

A table.

Is this what you mean?

insert into the_table_name
select 
  id, 
  house, 
  date( concat( 2022, substr(date_from,5) ) ), 
  date( concat( 2022, substr(date_to,5) ) ),
  price
  from the_table_name
  where year(date_from)=2021;