From: Warren Young Date: November 22 2004 10:21pm Subject: Re: Executing multiple table inserts and deletes List-Archive: http://lists.mysql.com/plusplus/3709 Message-Id: <41A26653.5090107@etr-usa.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit MailList wrote: > i have to do multiple inserts/deletes in one query. I'm trying to use semicolon to separate the commands, like this: > > DELETE FROM... ; INSERT INTO ... ; INSERT INTO... This is a SQL syntax question, not a MySQL++ question. Take it to the mysql mailing list. > Another question (it's more about mysql) If you know already that it's off topic, why are you posting it here?