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 |