xxxxxxxxxx
1. InnoDB
2. MyISAM
3. Memory
4. CSV
5. Merge
6. Archive
7. Federated
8. Blackhole
xxxxxxxxxx
# Show available storage engines in mysql
SHOW ENGINES;
# Default storage engine: InnoDB.
# Creating Table with other engines
CREATE TABLE table_1 (id INT) ENGINE = CSV;
CREATE TABLE table_2 (id INT) ENGINE = MEMORY;
# Set default engine
SET default_storage_engine=ARCHIVE;
# Alter engine for an existing table
ALTER TABLE table_1 ENGINE = MEMORY;