MYISAM engine : MyISAM « Engine « SQL / MySQL

1. SQL / MySQL
2. Engine
3. MyISAM

MYISAM engine

     
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>

   
    
    
    
    
  

Related examples in the same category