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