SELECT a,b,a+b INTO OUTFILE "/tmp/result.text"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM test_table;
[download]

use strict;
use DBI;

my $any_dbh   = DBI->connect('dbi:AnyData(RaiseError=>1):');
my $mysql_dbh = DBI->connect(
   qw(DBI:mysql:database:host user pass),
   {RaiseError=>1}
);

print $any_dbh->func( 
   'DBI', $mysql_dbh,
   'CSV', undef,
   {table_name=>'table'},
   'ad_convert',
);
[download]

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

()-()
 \"/
  `                                                     

*I say fairly easily but there are a number of gotchas involving dealing with data containg quotation marks and/or commas. There are functions in DBI that will make quoting these strings a bit easier.

As for a perl solution, gossamer-threads has a product called MysqlMan. It's based off of PHPMyAdmin. I've used it on many occasions. The best feature, imo, is the ability to make a dump file of all of the data in a database.