mysql SHOW ENGINES mysql CREATE TABLE city0 ENGINE InnoDB SELECT FROM

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
mysql> SHOW ENGINES;
mysql> CREATE TABLE city0 ENGINE=InnoDB SELECT * FROM world.city;
mysql> ALTER TABLE city0 ENGINE=InnoDB;
mysql> SELECT COUNT(*) FROM city0 c1
-> WHERE EXISTS (SELECT * FROM city0 c2 WHERE c1.name = c2.name);
mysql> CREATE TABLE city1 ENGINE=MyISAM SELECT * FROM world.city;
mysql> SELECT COUNT(*) FROM city1 c1
-> WHERE EXISTS (SELECT * FROM city1 c2 WHERE c1.name = c2.name);
mysql> CREATE TABLE city2 ENGINE=ARCHIVE SELECT * FROM world.city;
mysql> SELECT COUNT(*) FROM city2 c1
-> WHERE EXISTS (SELECT * FROM city2 c2 WHERE c1.name = c2.name);
mysql> CREATE TABLE city3 ENGINE=CSV SELECT * FROM world.city;
mysql> SELECT COUNT(*) FROM city3 c1
-> WHERE EXISTS (SELECT * FROM city3 c2 WHERE c1.name = c2.name);
mysql> CREATE TABLE city4 ENGINE=MEMORY SELECT * FROM world.city;
mysql> SELECT COUNT(*) FROM city4 c1
-> WHERE EXISTS (SELECT * FROM city4 c2 WHERE c1.name = c2.name);
mysql> CREATE TABLE city5 ENGINE=BLACKHOLE SELECT * FROM world.city;
mysql> SELECT COUNT(*) FROM city5 c1 WHERE EXISTS (SELECT * FROM city5 c2 WHERE c1.name = c2.name);