6 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 ideas that make sophisticated applications possible.

The chapter begins by discussing database design in greater detail, using a message board as the example. More elaborate databases like a forum require SQL queries called joins, so that subject will follow. From there, the chapter introduces a category of functions that are specifically used when grouping query results.

After that, the subjects turn to advanced MySQL concepts: indexes, changing the structure of existing tables, and table types. The chapter concludes with ...

Get PHP 6 and MySQL 5 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.