Chapter 5. Advanced SQL and MySQL
This chapter picks up where its predecessor left off, discussing more advanced SQL and MySQL topics. While the basics of both technologies will certainly get you by, it’s these more complex features that will take your Web applications to the next level.
I’ll begin by discussing database design in greater detail, using a content management system as an example. This naturally leads into the SQL topic of joins, an integral part of any relational database. The bulk of the material will then introduce some of MySQL’s built-in functions. Finally, you’ll learn about indexes and how to change the structure of existing tables.
Get PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide 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.
