1CREATE SCHEMA schema1;
2CREATE SCHEMA schema2;
3USE schema1;
4CREATE TABLE real_table (f1 INTEGER) ENGINE=InnoDB;
5CREATE TEMPORARY TABLE temp_table (f1 INTEGER) ENGINE=InnoDB;
6CREATE TABLE myisam_table (f1 INTEGER) ENGINE=MyISAM;
7USE schema2;
8CREATE TABLE real_table1 LIKE schema1.real_table;
9CREATE TABLE real_table2 LIKE schema1.temp_table;
10CREATE TABLE real_table3 LIKE schema1.myisam_table;
11CREATE TEMPORARY TABLE temp_table1 LIKE schema1.real_table;
12CREATE TEMPORARY TABLE temp_table2 LIKE schema1.temp_table;
13CREATE TEMPORARY TABLE temp_table3 LIKE schema1.myisam_table;
14SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'real_table' AND TABLE_SCHEMA = 'schema1';
15COUNT(*) = 1
161
17SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'myisam_table' AND TABLE_SCHEMA = 'schema1';
18COUNT(*) = 1
191
20SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'temp_table' AND TABLE_SCHEMA = 'schema1';
21COUNT(*) = 0
221
23SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'real_table1' AND TABLE_SCHEMA = 'schema2';
24COUNT(*) = 1
251
26SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'real_table2' AND TABLE_SCHEMA = 'schema2';
27COUNT(*) = 1
281
29SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'real_table3' AND TABLE_SCHEMA = 'schema2';
30COUNT(*) = 1
311
32SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'temp_table1' AND TABLE_SCHEMA = 'schema2';
33COUNT(*) = 0
341
35SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'temp_table2' AND TABLE_SCHEMA = 'schema2';
36COUNT(*) = 0
371
38SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'temp_table3' AND TABLE_SCHEMA = 'schema2';
39COUNT(*) = 0
401
41DROP TABLE schema1.real_table;
42DROP TABLE schema1.myisam_table;
43DROP TABLE schema2.real_table1;
44DROP TABLE schema2.real_table2;
45DROP TABLE schema2.real_table3;
46DROP SCHEMA schema1;
47DROP SCHEMA schema2;
48