insert into duplicate



  1. INSERT INTO `affilinet_data` (`id`, `date`, `program_id`, `raw_data`) VALUES
  2. (778,   '2018-06-08 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  3. (779,   '2018-06-09 00:00:00',  '16987',        '[]'),
  4. (780,   '2018-06-10 00:00:00',  '16987',        '[]'),
  5. (781,   '2018-07-02 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  6. (782,   '2018-07-03 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  7. (783,   '2018-07-04 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  8. (784,   '2018-07-05 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  9. (785,   '2018-07-06 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  10. (786,   '2018-07-07 00:00:00',  '16987',        '[]'),
  11. (787,   '2018-07-08 00:00:00',  '16987',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  12. (788,   '2018-12-11 00:00:00',  '14853',        '[{\"Bonus\":{\"Count\":{\"CancelledCount\":0,\"ConfirmedCount\":0,\"OpenCount\":0},\"NetworkFee\":{\"CancelledValue\":0,\"ConfirmedValue\":0,\"OpenValue\":0},\"PublisherCommission\":{\"C$
  13. ON DUPLICATE KEY UPDATE `id` = VALUES(`id`), `date` = VALUES(`date`), `program_id` = VALUES(`program_id`), `raw_data` = VALUES(`raw_data`);
  14.  

Posted by GT at 12 Dec 2018, 13:10:15 CET
Language: sql