Author Archives: thomas

Dumping a SQL query into a CSV file in MySQL

Yet another note to myself… SELECT order_id,product_name,qty FROM orders INTO OUTFILE ‘/tmp/orders.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ Credit to http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ (Since this apparently doesn’t work with one of the versions of MySQL I use, … Continue reading

Posted in Technology | Tagged | Leave a comment

Alameda County Water District Water Treatment Plant No. 2

Aerial photograph of Alameda County Water District’s Water Treatment Plant No. 2 in Fremont, California.

Posted in Civil and Environmental Engineering | Tagged , , , , , | Leave a comment

Cycle for Sight 2018

This past Saturday, Leslie and I rode in the annual Cycle for Sight ride up in Napa.  The ride is a benefit for local charities including the Pathway Home and the Enchanted Hills Camp for the Blind. The Ride   … Continue reading

Posted in Outdoors and Travel | Tagged , , , , | Leave a comment

Swallowtail Butterflies

Butterflies enjoying a sunny afternoon near Coloma, California

Posted in Nature, Photography | Tagged , , , , , | Leave a comment

Made Me Smile on the Way to Work

Posted in Snapshots | Tagged , | Leave a comment