List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:September 17 2007 7:34pm
Subject:RE: Generating reports/exporting data?
View as plain text  
It's not "free" in that you have to buy the product, but it is "free" in
that you make ONE report and get multiple export modules that you don't have
to write yourself. That alone is awesome!


> -----Original Message-----
> From: chombee [mailto:chombee@stripped] 
> Sent: Monday, September 17, 2007 8:29 AM
> To: mysql@stripped
> Subject: Generating reports/exporting data?
> Can anyone recommend an easy, free way to generate reports 
> from a MySQL
> database in a nicely readable form? e.g. in plain text, HTML, PDF, or
> even visualised in the form of graphs and charts.
> For example, if I have constructed several queries and want 
> to run them
> and export all of their results to a file. Or I have a query that runs
> over one row of a table by specifying a specific primary key value in
> the query and I want to run it on each row of the table by 
> incrementing
> the primary key and then compute totals and averages on the 
> results. In
> general I want to be able to run lots of queries, do simple 
> calculations
> on their results, and display all these results alongside 
> each other in
> one file.
> I'm aware that the mysql client can run in batch mode and has HTML and
> XML output options, but this is a little too simple for what I want.
> Currently I'm using Python's MySQLdb module and rolling my 
> own scripts,
> but I was hoping there would be something a little faster. I started
> writing Python scripts to take user input from the keyboard 
> and pass it
> to mysql, but then I discovered mysqlimport which was much quicker, so
> I'm hoping something similar exists for outputting reports.
> Thanks
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe:    

Generating reports/exporting data?chombee17 Sep
  • RE: Generating reports/exporting data?Daevid Vincent17 Sep
    • Re: Generating reports/exporting data?Michael Dykman17 Sep