Re:Advanced SQL window function quiz
by zimpenfish on Friday February 09, 2018 @05:24AM
(#16339209)
I 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.)
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...