mysql>
mysql> CREATE TABLE SEXES
-> (SEX CHAR(1) NOT NULL PRIMARY KEY)
-> ENGINE = MYISAM;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> SELECT TABLE_NAME, ENGINE
-> FROM INFORMATION_SCHEMA.TABLES
-> WHERE TABLE_NAME IN ('EmployeeS', 'PENALTIES', 'SEXES');
+------------+--------+
| TABLE_NAME | ENGINE |
+------------+--------+
| sexes | MyISAM |
+------------+--------+
1 row in set (0.00 sec)
mysql>
mysql> drop table sexes;
Query OK, 0 rows affected (0.00 sec)
mysql>
|