Hi.
You can set the default storage engine for the session by issuing:
-
SET storage_engine=MYISAM;
-
Or, you can set the engine for each individual table like so:
-
CREATE TABLE t (i INT) ENGINE = MYISAM;
-
To alter the engine for a table that already exists, you can do:
-
ALTER TABLE t ENGINE = MYISAM;
-
If this is not what you are talking about, please elaborate.