Daniel J. Choi

Export MySQL Query Results to CSV

Dev

If you’re SSH’d into a MySQL server and want to export MySQL query results to CSV (readable by Excel), simply add the below snippet to the end of your query.

INTO OUTFILE '/tmp/results.csv' 
FIELDS TERMINATED BY ',' ENCLOSED BY '"' 
LINES TERMINATED BY '\n'

Note that ‘/tmp/results.csv’ in the code above should correspond to a writeable destination, and the file can’t already exist.

Read Next

CS 175: Graphics Final Project

Dev

For my final project in Computer Science 175: Intro to Graphics, I created a maze game with a buddy of mine. Click here for the project website – you can check out screen shots and even download the source if you’re interested!

How to Remove the Top Border from Drupal Tables

Dev

I’ve been very busy developing a couple projects over the past couple days, but here is a quick little trick to get around one of Drupal’s quirks. If you’re unfamiliar with Drupal, it’s a fantastic CMS (content management system) built on PHP and MySQL. For those blog-savvy among us, it is to general websites what WordPress is to blogs. I use Drupal to get sites up quickly and with great functionality, and I highly recommend it to anyone who is looking to build powerful, custom websites without “re-inventing the wheel.”

Anyway, Drupal has this strange quirk in its source that creates a small grey border on the top of tables inserted in a page’s content.  A quick trip to my inspector revealed how to remove the top border from Drupal tables.  Simply add the following line to your CSS.

body tbody { border-top: none; }

All there is to it. 🙂

© 2026 Daniel J. Choi

Sliding Sidebar

My friends call me Dan.

Currently, building Loti.

Previously, co-founder @ Plastiq.

Recent Posts

Categories