Re: Select from 1 Database - insert in other - only when a field contains...

[Peter Brawley]

Is this what you mean?

insert into statistic_db.history ( device,reading,value ) 
  select device, reading, value 
  from history 
  where timestamp < date_sub(now(), interval 1 day) and reading like '%temp%';

There's no aggregation in the query, so the Group By would just arbitrarily select rows; what's that about?