From: Dan Nelson
Date: May 1 2003 4:50am
Subject: Re: Next issue:  Can't execute multiple statements?
List-Archive: http://lists.mysql.com/mysql/138854
Message-Id: <20030501045032.GH90046@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Apr 30), TheMechE said:
> Scenario 1.
> 
> I build String.  I pass to execute() Here is the results...
> 
> All from my log writer
> 20030430.145301 Delete from Licenses where LicenseID = 269;Delete From
> LicenseRules Where LicenseID = 269;Delete from Categories where categoryID
> IN (-1) ;Delete from LicenseSlaves where MasterID = 269 OR SlaveID = 269;

Send four separate queries (or upgrade to mysql 4.1).  Even with 4.1, I
recommend sending four queries, because that way you can error-check
each statement.
 
-- 
	Dan Nelson
	dnelson@stripped