1 DROP TABLE IF EXISTS t1,t2;
2 drop database if exists mysqltest;
4 pk1 INT NOT NULL PRIMARY KEY,
10 INSERT INTO t1 VALUES (0,0,0,"zero"),(1,1,1,"one"),(2,2,2,"two");
11 SELECT * FROM t1 WHERE attr1 = 1;
14 alter table t1 rename t2;
15 SELECT * FROM t2 WHERE attr1 = 1;
18 create database ndbtest;
19 alter table t2 rename ndbtest.t2;
20 SELECT * FROM ndbtest.t2 WHERE attr1 = 1;
23 drop table ndbtest.t2;
24 drop database ndbtest;