O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2

Managing Data with MySQL

In This Chapter

arrow Working with SQL script files

arrow Using AUTO_INCREMENT to build primary key values

arrow Selecting a subset of fields

arrow Displaying a subset of records

arrow Modifying your data

arrow Deleting records

arrow 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required