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
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.
Although you can use phpMyAdmin to build databases, all it really does is write and execute SQL code for you. You should ...