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 |