is CREATE TABLE not transactional?

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

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




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]