Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SELECT *
FROM reports.report_utilization ru
where (ru.service_type='LMD')
AND (ru.year="2018")
AND (ru.month="12")
and base_absid in (24091 ,24241 ,24147 ,22211 ,24167 ,41759 ,42367
,27069 ,36741 ,28565 ,19095 ,37917 ,24193 ,23603
,23661 ,43729 ,34043 ,34041 ,5765 ,40143 ,40435)
order by base_absid;

Step 5:

Then import the CSV fileImport the CSV file (import records from an external file) icon in MySQL Workbench, find the CSV on your machine (generated in Step 2 above) and then click the "Apply" button.