View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 09:25 AM
Peter H. Coffin
 
Posts: n/a
Default Re: Do sourced queries automatically commit?

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?

--
I wish there was a knob on the TV to turn up the intelligence. There's a
knob called "brightness", but it doesn't work.
-- Gallagher
Reply With Quote