|
Explain how to create a new table using InnoDB Storage Engine.- InnoDB storage engine is transaction safe and developed by Oracle.
- InnoDB is not the default storage engine. "ENGINE = InnoDB" at the end of the "CREATE TABLE" statement can be specified to create new tables with InnoDB as the storage engine.
- You do not need to specify the ENGINE=InnoDB clause if InnoDB is defined as the default storage engine, which is the default as of MySQL 5.5.
- You might still use ENGINE=InnoDB clause if you plan to use mysqldump or replication to replay the CREATE TABLE statement on a server where the default storage engine is not InnoDB.
|
