View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 10:26 AM
Captain Paralytic
 
Posts: n/a
Default Re: Do sourced queries automatically commit?

On 19 Mar, 16:13, "Ham Pastrami" <nom...@dot.com> wrote:
> "Peter H. Coffin" <hell...@ninehells.com> wrote in messagenews:slrnevt157.nmn.hellsop@abyss.ninehells .com...
>
> > On Sun, 18 Mar 2007 17:31:10 -0700, Ham Pastrami wrote:
> > > Greetings all, I am trying to track down the cause of some issues I'm
> > > having. I am doing this from the mysql prompt:

>
> > > start transaction;
> > > source c:/queries.sql;
> > > rollback;

>
> > > When I examine the db though, it appears that the changes from the

> sourced
> > > queries have been committed.

>
> > What type/engine are the affected tables?

>
> MyISAM.


MyISAM does not support transactions

Reply With Quote