3 ms·
InnoDB storage engine is available in 5.4, you don't have to use only MyISAM[1]. However, depending on your application, you may be enforcing these constraints
by Alupis 9y ago
InnoDB storage engine is available in 5.4, you don't have to use only MyISAM[1].
However, depending on your application, you may be enforcing these constraints elsewhere and not need them at the engine level, even if it's a nice-to-have.
[1] http://download.nust.na/pub6/mysql/doc/refman/5.4/en/storage-engines.html http://download.nust.na/pub6/mysql/doc/refman/5.4/en/storage...
- zimpenfish 9y agoI know a database that's using InnoDB tables but also has no foreign keys and, indeed, JOINs are forbidden. (And yes, the workflow does include actions that involve multiple tables in one go.)