This recipe uses the MySQL database, tables, as well as the data inserted into those tables from the previous recipe, Using the SQL UPDATE command. In order to demonstrate how to create orphan records, we will have to change the design of one of our database tables.