Re: is CREATE TABLE not transactional?

>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

>
>mysql> BEGIN WORK;
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> CREATE TABLE foo (bar int) TYPE=InnoDB;
>Query OK, 0 rows affected, 1 warning (0.03 sec)
>
>mysql> ROLLBACK;
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> SHOW TABLES;
>
>And my newly created "foo" table shows up on the list, even though i've
>rolled back the transaction. Is there any way to fix this??
>
>	Thanks,
>		Tyler

-- 
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]