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;