Here’s an email from a good friend of mine that may be of interest. It is done in Ruby. From: Brad Robel-Forrest [mailto:b...@gigglewax.com] Sent: Sunday, May 15, 2011 7:01 PM To: Daevid Vincent Subject: MySQL shell...with parameters Remember a long while back I was bitching about the need for parameterized MySQL when working at the prompt? Well, it took me down a road and I've fulfilled that need and many more. If you're interested, I've opened a project on a shell that allows you to write all manner of SQL queries with variable interpolation and even generated query for programmatic searching through your database. Plus, it has the ability to do all of this remotely over an SSH connection without needing to have a mysql binary installed either locally or remotely. Main project site: https://github.com/bradrf/rsql Installing on Windows: https://github.com/bradrf/rsql/wiki/Install-on-Windows Tutorial: https://github.com/bradrf/rsql/raw/master/example.rsqlrc I've been using it a ton for analyzing our database at work for the past several months. It's a rare day that goes by where I don't fire this up.
-brad