git.rot13.org Git - eg5120/blob - nl_new.sql

   1
   2 create temporary table nl_received as select _id,json->'received' as received from nodelog where json->'received' is not null;
   3
   4 create temporary table eg_received as select _id,json->'received' as received from eg5120 where json->'received' is not null;
   5
   6 select count(*) from nl_received where received not in (select received from eg_received) ;
   7
   8 create table nl_new as select * from nl_received where received not in (select received from eg_received) ;
   9
  10 select time,mac,addr,"nodeId",json,_id,sensor_type from nodelog where _id in (select _id from nl_new);
  11
  12 --insert into eg5120 select time,mac,addr,"nodeId",json,sensor_type from nodelog where _id in (select _id from nl_new);