execute multiple queries on a MYSQL database

Posted on 2005-04-29
Last Modified: 2012-06-27
Hello Experts,

I am trying to build software which can execute queries on a mysql database using myodbc.
Now, my problem is that i want to execute multiple queries at once. I found out at the MYSQL site to use that possibility I got to set the option (MYSQL_OPTION_MULTI_STATEMENTS_ON) but I have NO idea how to do this. Executing queries is simple: dbcon.execute "your query" but this is different so I have absolutely no idea how to do this and there is almost no information about this. So anyone wants to help me out?

Thanks in advance.
Question by:WarLord
    LVL 12

    Expert Comment

    not sure if this is it, and I'm not sure how to invoke it, but I googled this:

    LVL 12

    Expert Comment


    Author Comment

    yes, I found those aswell but the problem is to execute those command's which i don't know how.
    LVL 11

    Accepted Solution


    mysql_set_server_option() is not supported older than 4.1.1 of MySQL Servers.

    To run this command
    1. Goto Command Prompt, Navigate to c:\mysql\bin and run mysql.exe
    2. run the command mysql_set_server_option(MYSQL_OPTION_MULTI_STATEMENTS_ON) on MySQL Command Prompt.


    Author Comment

    So it needs to be executed in mysql itself??

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now