Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Viewing contents of a MySQL database

Options
  • 24-07-2004 6:15pm
    #1
    silverside
    Registered Users Posts: 1,372 ✭✭✭


    I am doing some scientific simulations and storing the results in a MySQL database.
    I am writing to the database via ODBC. The database is quite simple (4 tables).

    Now I want to analyse my results.

    My original plan was
    Create a view of the data in MySQL
    Use Excel to use this view as an ODBC datasource
    Plot the data

    BUT
    Views arent supported in MySQL.

    So what should I do? Convert everything to SQL Server ( I see there is a free beta version of SQL Server 2005 lite available)?

    Is there a better alternative?

    Bear in mind that I want something
    Free
    Simple to use
    Database performance is not really an issue; This is not and never will be a production system.

    Thanks


Comments

  • Options
    #2
    Ivan Dunaev
    Closed Accounts Posts: 35 ✭Ivan Dunaev


    write simple app, which will store result of your SQL-query into csv-file
    then open it with excel


  • Options
    #3
    silverside
    Registered Users Posts: 1,372 ✭✭✭silverside


    Thanks

    I realised i can just create a dummy table instead of a view.
    I tried installing SqlServer 2005 but couldnt find any visual management tools for it; I will stick to MySQL for the moment.


Advertisement