Drizzled Public API Documentation

create_select.inc

00001 #
00002 # Test that create with select works 
00003 #
00004 
00005 --disable_warnings
00006 DROP TABLE IF EXISTS t1;
00007 DROP TABLE IF EXISTS t2;
00008 --enable_warnings
00009 
00010 CREATE 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 (
00019   id INT NOT NULL PRIMARY KEY
00020 , padding VARCHAR(200) NOT NULL
00021 ) SELECT * FROM t1;
00022 
00023 DROP TABLE t1, t2;