Chapter 2

Building and Querying MySQL Databases

IN THIS CHAPTER

Bullet Learning about MySQL and what it can do

Bullet Building MySQL databases and tables

Bullet Getting your head around SQL

Bullet Selecting data with queries

Bullet Modifying data with queries

MySQL is a fast and powerful, yet easy-to-use, database system that offers just about anything a website would need in order to find and serve up data to browsers.

— ROBIN NIXON

One of the central themes of this book is that today’s web is all about dynamic content. Sure, if you have (or your client has) just one or two web pages to show the world, the standard front-end web development tools — HTML, CSS, and JavaScript — are more than enough to get the job done. However, it’s much more likely that a modern website will consist of dozens, perhaps even hundreds, of pages, with new content added regularly. Believe me, as the developer or administrator of such a site, you don’t want to hand-code all those pages as static HTML and CSS. Life’s too short!

Fortunately, ...

Get Web Coding & Development All-in-One For Dummies, 2nd 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.