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.

CountryGoldSilverBronzeTotal
Russia1311933
United States971228
Norway1151026
Canada1010525
Netherlands87924

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.