Re: is CREATE TABLE not transactional? - Paul DuBois - com.mysql.lists.perl

7 messages in com.mysql.lists.perlRe: is CREATE TABLE not transactional?

Subject:	Re: is CREATE TABLE not transactional?
From:	Paul DuBois (pa...@mysql.com)
Date:	02/16/2006 03:13:07 PM
List:	com.mysql.lists.perl

Is CREATE TABLE not protected by transactions in MySQL? I just tried doing this:

See:

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