#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    10
    Rep Power
    0
    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
    do this.

    Does anyone know of a way around this?
    Thanks.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    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.

    See http://web.mysql.com/Manual_chapter/...ols.html#mysql
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    10
    Rep Power
    0
    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?

Similar Threads

  1. php and mysql query results on multiple pages
    By CRO8 in forum PHP Development
    Replies: 6
    Last Post: November 3rd, 2003, 07:53 AM
  2. Formatting MySql query results in PHP
    By Broderick in forum PHP Development
    Replies: 4
    Last Post: August 6th, 2003, 03:34 PM
  3. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 11:05 AM
  4. mysql query results downloadable to excel?
    By strimp099 in forum PHP Development
    Replies: 1
    Last Post: July 24th, 2003, 06:04 AM
  5. mysql query to join results...
    By deanbayley in forum PHP Development
    Replies: 2
    Last Post: July 4th, 2003, 08:45 AM

IMN logo majestic logo threadwatch logo seochat tools logo