-
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
-
Tag Archives: database
Joining a table to itself in MySQL
Joining a table to itself is a technique that, while moderately painful to contemplate, can prove quite valuable in making certain updates possible. Consider an example case where we have a table containing various company names, some of which actually … Continue reading
MySQL replication and flush tables with read lock gotcha
I ran into something that stumped me for a few minutes today while trying to setup some replicated databases in MySQL. As with any replication setup, you have to lock the master tables and note the binary log position via: … Continue reading
Search MySQL field names
I had occasion recently to map out a number of databases, some of which contained quite a few tables. I was not intimately familiar with most of them, and since they didn’t have foreign keys established in most cases, I … Continue reading