How to set storage to MyISAM?

[rob25]

How do I set storage to MyISAM?

[ronverdonk]

I do not understand your question so, what do you mean? storage for a table, to the MyISAM engine? Please elaborate a bit more.

Ronald

[Atli]

Hi.

You can set the default storage engine for the session by issuing:
[code=sql]
SET storage_engine= MYISAM;
[/code]
Or, you can set the engine for each individual table like so:
[code=sql]
CREATE TABLE t (i INT) ENGINE = MYISAM;
[/code]
To alter the engine for a table that already exists, you can do:
[code=sql]
ALTER TABLE t ENGINE = MYISAM;
[/code]

If this is not what you are talking about, please elaborate.