dp.cx blog

I, like most developers, am lazy (which is apparently a virtue!) and recently needed to remove a bunch of CREATE TABLE statements from a mysqldump. The vim macro below is how I accomplished that task.

I created sql2xls.pl initially about 6 months ago, because I was tired of trying to remember to MySQL's SELECT … INTO syntax. Plus, then I'd have to download the CSV, format it in a method that MS Office could use, and then email the data.