Versions Compared

Old Version 12

changes.mady.by.user Robert W Smyser

Saved on

compared with

New Version 13

changes.mady.by.user Robert W Smyser

Saved on

Key

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

...

The following query gets all the columns out of the database for all transactions between two dates, and streams it into a file for transferring elsewhere:

Panel

SYSTEM rm temp/downloads/2010-06.txt
;
TEE temp/downloads-2010-06.txt
;
SELECT download_uri, download_date, user_id, user_class, user_affiliation, ip_address, user_agent
FROM download_log
WHERE download_date BETWEEN
'2010-06-01' AND '2010-06-30'
;
NOTEE
;

This one will summarize the download counts per filename:with a within-the-month date stamp

...