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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]