How to Update a Table Based on the Results of a Previous Query Using MariaDB and Correlated Subqueries

The Incorrectly Formed Foreign Key Constraint Error: A Guide to Correcting Foreign Key Constraints in MySQL