Category Archives: Technology

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/

Posted in Technology | Tagged | Leave a comment

MS Office 2010 – Grammar Check Fail

Upgraded to Microsoft Office 2010 over the weekend at work. Unfortunately, it seems to have trouble telling the difference between “it is” and “it belongs to.” Update: One day later and we’re still having troubles – this time in MS … Continue reading

Posted in Technology | Tagged , , | Leave a comment

MS Windows Batch Files – Doing Something to Each File in a Directory

Again, a note primarily for my reference… To process each file in a directory using a batch file, the syntax would be for %%f in (*.txt) do type %%f From the command line it would be for %f in (*.txt) … Continue reading

Posted in Technology | Tagged , | Leave a comment

Moving to a Different Cell in an Excel Macro, Relatively Speaking

Primarily a note to myself, but… … in Microsoft Excel, the Macro Recorder defaults to storing an absolute cell address when recording a macro.  I seem to typically want a relative address, such as “three cells to the left.”  I … Continue reading

Posted in Technology | Tagged , , | Leave a comment