Versions Compared

Old Version 9

changes.mady.by.user Robert W Smyser

Saved on

compared with

New Version 10

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

TEE temp/downloads-2010-06.txt
;
SELECT download_date, download_uri, 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 ;

...