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 database-driven applications to the next level.
I’ll begin by discussing database design in greater detail, using part of a content management system as an example. This naturally leads into the SQL topic of joins, an integral part of any relational database. From there I’ll describe a new category of functions that are specifically used when grouping your query results.
After that discussion, the subject matter becomes more advanced, starting with indexes, how to change the structure of existing tables, ...
Get PHP and MySQL for Dynamic Web Sites: Visual Quickpro Guide, Second 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.