Change table engine
mysql> mysql> mysql> CREATE TABLE TEAMS -> (TEAMNO INTEGER NOT NULL, -> EmployeeNO INTEGER NOT NULL, -> DIVISION CHAR(6) NOT NULL, -> PRIMARY KEY (TEAMNO) ); Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> INSERT INTO TEAMS VALUES (1, 6, 'first'); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO TEAMS VALUES (2, 27, 'second'); Query OK, 1 row affected (0.00 sec) mysql> mysql> ALTER TABLE TEAMS -> ENGINE = MYISAM; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> mysql> mysql> drop table teams; Query OK, 0 rows affected (0.00 sec)
1. | Changing a Table Type |