In MySQL and MariaDB, all tables should have a primary key - especially InnoDB tables - this is almost common wisdom. But why? Let's discuss the reasons.