You can selectively assign storage engines at creation time by passing along the attribute TYPE=TABLE_TYPE, and you can convert a table later with the ALTER command or by using the mysql_convert_table_format script, which comes with your MySQL distribution.