7. Advanced SQL and MySQL

In This Chapter

Performing Joins 204

Grouping Selected Results 214

Advanced Selections 218

Performing FULLTEXT Searches 222

Optimizing Queries 230

Performing Transactions 234

Database Encryption 237

Review and Pursue 240

This, the last chapter dedicated to SQL and MySQL (although most of the rest of the book will use these technologies in some form or another), discusses the higher-end concepts often needed to work with more complicated databases, like those created in the previous chapter. The first such topic is the JOIN, a critical SQL term for querying normalized databases with multiple tables. From there, the chapter introduces a category of functions that are specifically used when grouping query results, followed ...

Get PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.