Mysql Tricks : Transactions

Transactions: Not all table types support transactions. BDB and INNODB type do support transactions.
     Assuming the server has NOT been started with --skip-bdb or --skip-innodb the following should work:

          mysql> create table tran_test (a int, b int) type = InnoDB;
          mysql> begin;
          mysql> insert into tran_test (a,b) values (1,2);

          mysql> select * from tran_test;
          select * from tran_test;
          +------+------+
          | a    | b    |
          +------+------+
          |    1 |    2 |
          +------+------+
          1 row in set (0.00 sec)

          mysql> rollback;

          mysql> select * from tran_test;
          select * from tran_test;
          Empty set (0.00 sec)

     Summary: rollback undoes everything and commit will save.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image