TEXT   17

query

Guest on 22nd August 2022 07:40:09 AM

  1. ============36561=================
  2. INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)
  3. VALUES ('','vehicle_type_wise_revenue_report_in_gate','0','1','1','1','0')
  4.  
  5. INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)
  6. VALUES ('','vehicle_type_wise_revenue_report_out_gate','0','1','1','1','0')
  7.  
  8. INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)
  9. VALUES ('','vehicle_type_wise_revenue_report_cps_gate','0','1','1','1','0')
  10. ==========end=====================
  11.  
  12. ==============35784==============
  13. INSERT INTO `sps_eod_report_select` (`eod_report_id`, `eod_report_name`, `status`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
  14. ('', 'mixed_transaction', 0, 1, 1, 1, 0, '2019-01-28 08:01:47', '2019-01-28 08:02:02', '0000-00-00 00:00:00');
  15. ==============end================
  16. ==============35810==================
  17. UPDATE `sps_eod_report_select` SET `eod_report_name` = 'cashier_wise_PT_report' WHERE `sps_eod_report_select`.`eod_report_id` = 17;
  18. ================end==================
  19. ================35787================
  20. INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)
  21. VALUES ('','vehicle_type_wise_revenue','0','1','1','1','0')
  22. ================

Raw Paste


Login or Register to edit or fork this paste. It's free.