• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2027
  • Last Modified:

execute multiple queries on a MYSQL database

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.
0
WarLord
Asked:
WarLord
  • 2
  • 2
1 Solution
 
PreeceCommented:
not sure if this is it, and I'm not sure how to invoke it, but I googled this:

mysql_set_server_option(MYSQL_OPTION_MULTI_STATEMENTS_ON)
0
 
WarLordAuthor Commented:
yes, I found those aswell but the problem is to execute those command's which i don't know how.
0
 
ajaikumarrCommented:
Hai,

mysql_set_server_option() is not supported older than 4.1.1 of MySQL Servers.
http://dev.mysql.com/doc/mysql/en/mysql-set-server-option.html

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.

Bye
Ajai
0
 
WarLordAuthor Commented:
So it needs to be executed in mysql itself??
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now