7 messages in com.mysql.lists.perlis CREATE TABLE not transactional?
FromSent OnAttachments
Tyler MacDonald16 Feb 2006 15:04 
Paul DuBois16 Feb 2006 15:13 
Tyler MacDonald16 Feb 2006 15:52 
Paul DuBois16 Feb 2006 16:09 
Tyler MacDonald16 Feb 2006 18:38 
Darren Duncan17 Feb 2006 16:11 
Tyler MacDonald17 Feb 2006 16:11 
Subject:is CREATE TABLE not transactional?
From:Tyler MacDonald (tyl@yi.org)
Date:02/16/2006 03:04:10 PM
List:com.mysql.lists.perl

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