MySQL Forums
Forum List  »  Ruby

multiple statements error
Posted by: Guilherme Antonio
Date: August 26, 2007 08:14AM

Hello, it's my first post here.

I'm using mysql Ver 14.12 Distrib 5.0.32 (Debian)

I've read the documents talking about handling multiple statements (http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html) but I'm not still able to make it work properly.

I'm trying to execute a bundle of statements *with no results* ("drop table person; drop table invoice").

At the first query, it works well. But when I execute the second one, mysql shots an error. "Commands out of sync. You can't run this command now".

I've enabled the CLIENT_MULTI_STATEMENTS in real_connect.

What am I missing?


thanks

Options: ReplyQuote


Subject
Written By
Posted
multiple statements error
August 26, 2007 08:14AM
August 11, 2008 09:13AM
December 24, 2008 09:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.