March 27th, 2000, 08:53 AM
I have MySQL 3.22.xx loaded and running as
a server. I need to be able to get MySQL to
execute a large query (such as a summary)
and then send the results back to MSAccess97
which will then generate reports from it.
I have found no way of storing the results of
a MySQL query - so that Access can get them easily - without having to create a C API to
Does anyone know of a way around this?
March 28th, 2000, 10:18 AM
Assuming your database is located on a Unix system, put your query commands in an external text file, and run the Mysql shell non-interactively (you pipe your commands in, and pipe the putput out), in which case you can pipe the output to any text file you want. For example the following command would be run from the standard command shell, not from the mysql command shell.
bash$ mysql database_name < script.sql > output.tab
Then mysql would run the query in script.sql, and output the results to output.tab, which would be delimited by whatever options you choose in your sql script.
March 30th, 2000, 04:29 AM
Thanks, that will work.
What I was also wondering was once you
have a file with a set of results from a query, how do you then base another query on them?