Working with multiple tables 19

W

ORKING WITH MULTIPLE TABLES

Where modern databases start to get both more confusing and more useful is when you start

making multiple tables and link them together. For example, we now have a list of all of our

albums, why not a list of all of the songs as well?

Import songs

Create a new table called  songs . This one will have a field for song, length, artist, album,

year, rating, track, and genre. Set up the ID as an auto increment field as we did for albums.

New for this table is the  time  field type. Our song length is going to be a time.

Import  songs.txt  as you earlier imported  albums.txt . Note that there is an extra field in

songs.txt that we are not importing: a combined date and time field.