-
What is this?
From advanced Bash tricks to Python gotchas to MySQL tutorials, this blog covers various topics in programming and systems administration. Find out how to get more done and have fun! Keep up with the latest by subscribing to the RSS feed!About the Author
This is the tech blog of Samuel Huckins. You can check out my homepage and other websites below, or send me a message here.-
-
Recent Posts
Post categories
Tags
Apache Apple Bash bookmarks CLI command database Desktop disk editor efficiency Excel filesystem firefox graph graphing hardware HTML information keyboard Launchy Linux logging migration Mobile monitoring MySQL PDF Programming putty Python Ruby scripting Security ssh subversion svn sysadmin Trac Ubuntu vim Vista web web applications WindowsBlogroll
Handy Links
My Sites
My del.icio.us
-
- Posts 190
- Words in Posts 69,510
- Comments 466
-
Monthly Archives: September 2009
Advanced ordering of MySQL results
MySQL’s “order by” keyword allows the order in which result rows are returned to be defined. This is quite useful in a wide variety of circumstances. You can specify any number of columns whose values you want to order the … Continue reading
Rapidly set up a MySQL database for testing
Sometimes you just want a database to run some queries against. Any reasonable set of tables with data pertaining to something not terribly complicated will do. Perhaps you have an urge to tease out the intricacies of correlated subqueries, or … Continue reading
Troubleshooting with MySQL binary logs
MySQL replication has a wide range of uses, including debugging applications writing to the DB being replicated. Once set up, all statements “that update data or potentially could have updated it” are stored in one or more binary logs (MySQL … Continue reading