[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