O'Reilly logo

Sams Teach Yourself MySQL by Chris Newman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Joins

The capability to join tables is probably the most important feature of MySQL, so it is important that you understand how to construct a SELECT statement that includes a join.

Understanding Relational Tables

MySQL is a relational database. This means that data records can be split across several tables in a logical way. You will learn how to design a relational database in Lesson 16, “Designing Your Database,” so for now, you’ll consider a simple example from the sample tables that you have already seen.

A relationship exists between the customers and customer_contacts tables. There might be more than one contact person for each customer, assuming that a customer is a company and that you can deal with people in different ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required