[Novalug] MySQL Reporting Tool
Jeff Stoner
leapfrog@freeshell.org
Wed Feb 27 15:20:56 EST 2008
On Wed, 27 Feb 2008, Jones, Tony wrote:
> Does anyone know of a command line SQL reporting tool for MySQL similar to Oracle SQL*Plus? I remember using Oracle SQL*Plus many years ago to produce snazzy ad-hoc reports for those users who wanted a special report. I would love to be able to use some or all of the functionality that the SQL*Plus reporting tool offers.
>
SQL*Plus includes a ton of features for producing formatted reports. MySQL
does not come with such a tool. The mysql monitor (program, console, CLI,
whatever you want to call it) has limited ability to format results -
tabular, tab-separated, HTML...but no support for headers, footers,
pagination, etc.
Perl and PHP make connecting, querying and working with results from MySQL
very easy. Perl was originally designed to generate text reports and does
it very well. PHP was designed for web pages but certainly isn't limited
to just outputting HTML, it's equally adept are writing plain text.
--Jeff
"I am not available for comment"
More information about the Novalug
mailing list