View Single Post

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

On Mon, 19 Mar 2007 21:25:09 GMT, Ham Pastrami wrote:
>
> "Peter H. Coffin" <hellsop@ninehells.com> wrote in message
> news:slrnevtg3c.nmn.hellsop@abyss.ninehells.com...
>> Easy answer then: MyISAM doesn't support transactions, nor rollback. You
>> want InnoDB instead. Change all the tables and try it again.

>
> Well don't I feel stupid. Thanks for the revelation.


*grin* If you make mistakes that have obvious and well-documented
solutions, you end up being able to fix them quickly and easily. Making
a really clever and unique mistake may mean *months* of research and
experimentation to fix. I prefer the easy answers.

--
56. My Legions of Terror will be trained in basic marksmanship. Any who
cannot learn to hit a man-sized target at 10 meters will be used for
target practice.
--Peter Anspach's list of things to do as an Evil Overlord
Reply With Quote