Drizzled Public API Documentation

temp_tables.inc

00001 # 
00002 # Simple test of the behaviour of the transaction log
00003 # when temporary tables are involved in certain events.
00004 #
00005 
00006 --disable_warnings
00007 DROP TABLE IF EXISTS t1, t2;
00008 --enable_warnings
00009 
00010 CREATE TEMPORARY TABLE t1 (
00011   id INT NOT NULL PRIMARY KEY
00012 , padding VARCHAR(200) NOT NULL
00013 );
00014 
00015 INSERT INTO t1 VALUES (1, "I love testing.");
00016 INSERT INTO t1 VALUES (2, "I hate testing.");
00017 
00018 CREATE TABLE t2 LIKE t1;
00019 
00020 INSERT INTO t2 SELECT * FROM t1;
00021 
00022 DROP TABLE t1;
00023 DROP TABLE t2;