Chapter 2Storing Data

Data stored in a relational database is organized into tables. A database table organizes data in a grid-like fashion, where each entry forms a row and each column identifies a specific value in the entry. To illustrate this, here’s a table showing the number of medals won by each of the top five medal-winning countries that participated in the 2014 Winter Olympic Games. Each row lists the country’s name, how many gold medals, silver medals, and bronze medals were won, and the total number of medals won.

United States971228

A table like the one above is “physical” in that we can see it printed in a book or drawn on a whiteboard. It’s limited ...

Get Jump Start MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.