MySQL
      My Structured Query Language

Lesson 3

Table with Relationship

les3-alter-table.jpg

Above is altered table for my Address List

Created Two Related Tables

added-tables.jpg

I don't know that this is working as I expected. I added a 'family' to my address list (as seen as the bottom record) but entering the family_id did not return in the list the family_name. So should have it. Or is this something that is revealed in a Query. It seems to me that it did not make "myaddress_list" simpler.