I did a little deeper reading and the MySQL C API (probably the same API
they wrote the ODBC driver with) does not support multiple statements
through most (if not all) of its "querying" interfaces:
http://dev.mysql.com/doc/mysql/en/mysql_query.html
http://dev.mysql.com/doc/mysql/en/mysql_real_q
Hey. Thanks.
First off, I meant to say semicolon (;) in my first post but I mistyped and
said comma by accident. I am trying to use semicolon as my delimiter. This
method works if I issue statements from PHPMyAdmin, but not through my ODBC
app.
However, your pseudocode made me realize something
For multiple statements in one submission, have you tried using a
semicolon ; not a comma , ?
(http://dev.mysql.com/doc/mysql/en/Entering_queries.html)
Each command may return a recordset of its own. Be prepared to either
cycle through the returned recordsets or ignore them as they arrive.
Wh
Victor, I think I found what you're referring to:
http://dev.mysql.com/doc/mysql/en/C_API_multiple_queries.html ...
"From version 4.1, MySQL supports the execution of multiple statements
specified in a single query string. To use this capability with a given
connection, you must specify the CLIEN
4.0.20a-max, just because I thought this was the most stable build.
"Victor Pendleton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What version of MySQL are you using? I believe multiple delimited
> statements are available in 4.1.x and later.
>
> Jeff Burgoon wrote:
> > I'm writ
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to i
