Drizzled Public API Documentation

multi_table.inc
00001 # 
00002 # Tests changes to multiple tables within the same transaction 
00003 #
00004 
00005 --disable_warnings
00006 DROP TABLE IF EXISTS t1, t2;
00007 --enable_warnings
00008 
00009 CREATE TABLE t1 (
00010   id INT NOT NULL PRIMARY KEY
00011 );
00012 
00013 CREATE TABLE t2 (
00014   id INT NOT NULL PRIMARY KEY
00015 );
00016 
00017 START TRANSACTION;
00018 INSERT INTO t1 VALUES (1);
00019 INSERT INTO t2 VALUES (1);
00020 COMMIT;
00021 
00022 START TRANSACTION;
00023 UPDATE t1 SET id=2 WHERE id=1;
00024 UPDATE t2 SET id=2 WHERE id=1;
00025 COMMIT;
00026 
00027 START TRANSACTION;
00028 DELETE FROM t1 WHERE id=2;
00029 DELETE FROM t2 WHERE id=2;
00030 COMMIT;
00031 
00032 DROP TABLE t1, t2;