HTML5 and CSS3 All-in-One For Dummies, 3rd Edition

Chapter 2

Managing Data with MySQL

In This Chapter

Working with SQL script files

Using AUTO_INCREMENT to build primary key values

Selecting a subset of fields

Displaying a subset of records

Modifying your data

Deleting records

Exporting your data

Although we tend to think of the Internet as a series of interconnected documents, the web is increasingly about data. The HTML and CSS languages are still used to manage web documents, but SQL (Structured Query Language) — the language of data — is becoming increasingly central. In this chapter, you discover how SQL is used to define a data structure, add data to a database, and modify that data.

Writing SQL Code by Hand

Although you can use phpMyAdmin to build databases, all it really does is write and execute SQL code for you. You should ...