INSERT INTO `conso_jour` (`timestamp`,`rec_date`,`periode`,`hp`,`hc`,`idx_max_hp`,`idx_min_hp`,`idx_max_hc`,`idx_min_hc`,`id_eq`,`temp_max`,`temp_min`,`temp_moy`,`dju`,`dju_clim`) VALUES (unix_timestamp('2020-04-21 23:59:59'),'2020-04-21',DATE_FORMAT('2020-04-21','%a %e %y'),5.682,0,5682,0,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-22 23:59:59'),'2020-04-22',DATE_FORMAT('2020-04-22','%a %e %y'),13.849,0,19531,5682,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-23 23:59:59'),'2020-04-23',DATE_FORMAT('2020-04-23','%a %e %y'),13.878,0,33409,19531,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-24 23:59:59'),'2020-04-24',DATE_FORMAT('2020-04-24','%a %e %y'),15.421,0,48830,33409,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-25 23:59:59'),'2020-04-25',DATE_FORMAT('2020-04-25','%a %e %y'),15.087,0,63917,48830,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-26 23:59:59'),'2020-04-26',DATE_FORMAT('2020-04-26','%a %e %y'),9.356,0,73273,63917,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-27 23:59:59'),'2020-04-27',DATE_FORMAT('2020-04-27','%a %e %y'),8.937,0,82210,73273,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-28 23:59:59'),'2020-04-28',DATE_FORMAT('2020-04-28','%a %e %y'),6.67,0,88880,82210,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-29 23:59:59'),'2020-04-29',DATE_FORMAT('2020-04-29','%a %e %y'),10.248,0,99128,88880,0,0,857,0,0,0,0,0), (unix_timestamp('2020-04-30 23:59:59'),'2020-04-30',DATE_FORMAT('2020-04-30','%a %e %y'),5.997,0,105125,99128,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-01 23:59:59'),'2020-05-01',DATE_FORMAT('2020-05-01','%a %e %y'),3.345,0,108470,105125,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-02 23:59:59'),'2020-05-02',DATE_FORMAT('2020-05-02','%a %e %y'),7.284,0,115754,108470,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-03 23:59:59'),'2020-05-03',DATE_FORMAT('2020-05-03','%a %e %y'),13.003,0,128757,115754,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-04 23:59:59'),'2020-05-04',DATE_FORMAT('2020-05-04','%a %e %y'),18.219,0,146976,128757,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-05 23:59:59'),'2020-05-05',DATE_FORMAT('2020-05-05','%a %e %y'),11.764,0,158740,146976,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-06 23:59:59'),'2020-05-06',DATE_FORMAT('2020-05-06','%a %e %y'),14.383,0,173123,158740,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-07 23:59:59'),'2020-05-07',DATE_FORMAT('2020-05-07','%a %e %y'),18.306,0,191429,173123,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-08 23:59:59'),'2020-05-08',DATE_FORMAT('2020-05-08','%a %e %y'),16.795,0,208224,191429,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-09 23:59:59'),'2020-05-09',DATE_FORMAT('2020-05-09','%a %e %y'),18.073,0,226297,208224,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-10 23:59:59'),'2020-05-10',DATE_FORMAT('2020-05-10','%a %e %y'),8.792,0,235089,226297,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-11 23:59:59'),'2020-05-11',DATE_FORMAT('2020-05-11','%a %e %y'),12.168,0,247257,235089,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-12 23:59:59'),'2020-05-12',DATE_FORMAT('2020-05-12','%a %e %y'),6.822,0,254079,247257,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-13 23:59:59'),'2020-05-13',DATE_FORMAT('2020-05-13','%a %e %y'),3.033,0,257112,254079,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-14 23:59:59'),'2020-05-14',DATE_FORMAT('2020-05-14','%a %e %y'),4.139,0,261251,257112,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-15 23:59:59'),'2020-05-15',DATE_FORMAT('2020-05-15','%a %e %y'),6.357,0,267608,261251,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-16 23:59:59'),'2020-05-16',DATE_FORMAT('2020-05-16','%a %e %y'),18.399,0,286007,267608,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-17 23:59:59'),'2020-05-17',DATE_FORMAT('2020-05-17','%a %e %y'),19.228,0,305235,286007,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-18 23:59:59'),'2020-05-18',DATE_FORMAT('2020-05-18','%a %e %y'),18.852,0,324087,305235,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-19 23:59:59'),'2020-05-19',DATE_FORMAT('2020-05-19','%a %e %y'),18.927,0,343014,324087,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-20 23:59:59'),'2020-05-20',DATE_FORMAT('2020-05-20','%a %e %y'),19.005,0,362019,343014,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-21 23:59:59'),'2020-05-21',DATE_FORMAT('2020-05-21','%a %e %y'),18.919,0,380938,362019,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-22 23:59:59'),'2020-05-22',DATE_FORMAT('2020-05-22','%a %e %y'),16.679,0,397617,380938,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-23 23:59:59'),'2020-05-23',DATE_FORMAT('2020-05-23','%a %e %y'),4.217,0,401834,397617,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-24 23:59:59'),'2020-05-24',DATE_FORMAT('2020-05-24','%a %e %y'),19.14,0,420974,401834,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-25 23:59:59'),'2020-05-25',DATE_FORMAT('2020-05-25','%a %e %y'),19.339,0,440313,420974,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-26 23:59:59'),'2020-05-26',DATE_FORMAT('2020-05-26','%a %e %y'),19.455,0,459768,440313,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-27 23:59:59'),'2020-05-27',DATE_FORMAT('2020-05-27','%a %e %y'),19.412,0,479180,459768,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-28 23:59:59'),'2020-05-28',DATE_FORMAT('2020-05-28','%a %e %y'),19.256,0,498436,479180,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-29 23:59:59'),'2020-05-29',DATE_FORMAT('2020-05-29','%a %e %y'),19.497,0,517933,498436,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-30 23:59:59'),'2020-05-30',DATE_FORMAT('2020-05-30','%a %e %y'),18.914,0,536847,517933,0,0,857,0,0,0,0,0), (unix_timestamp('2020-05-31 23:59:59'),'2020-05-31',DATE_FORMAT('2020-05-31','%a %e %y'),19.073,0,555920,536847,0,0,857,0,0,0,0,0), (unix_timestamp('2020-06-01 23:59:59'),'2020-06-01',DATE_FORMAT('2020-06-01','%a %e %y'),18.938,0,574858,555920,0,0,857,0,0,0,0,0), (unix_timestamp('2020-06-02 23:59:59'),'2020-06-02',DATE_FORMAT('2020-06-02','%a %e %y'),18.722,0,593580,574858,0,0,857,0,0,0,0,0);