Re: is CREATE TABLE not transactional?
Paul DuBois <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <p06230912c01ac44a3b20@[192.168.1.35]> |
At 15:52 -0800 2/16/06, Tyler MacDonald wrote: >Paul DuBois <[email protected]> wrote: >> >Is CREATE TABLE not protected by transactions in MySQL? I just tried doing >> >this: >> >> See: >> >> http://dev.mysql.com/doc/refman/5.0/en/implicit-commit.html > > Okay, so it's documented at least.. I guess the new question now is >"why?!?!?!"... they actually *added* this functionality in 5.0.8, to serve >what purpose? :-( In effect, it's always been that way. The 4.1 page is here: http://dev.mysql.com/doc/refman/4.1/en/implicit-commit.html So it's caused an implicit transaction before 4.1.13 (and 5.0.0 which came out about the same time) if the binary log was enabled. But that log generally *should* be enabled. As to the why ... dunno. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]