O'Reilly logo

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fourth Edition by Larry Ullman

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

5. Introduction to SQL

In This Chapter

Creating Databases and Tables 130

Inserting Records 133

Selecting Data 138

Using Conditionals 140

Using LIKE and NOT LIKE 143

Sorting Query Results 145

Limiting Query Results 147

Updating Data 149

Deleting Data 151

Using Functions 153

Review and Pursue 164

The preceding chapter provides a quick introduction to MySQL. The focus there is on two topics: using MySQL’s rules and data types to define a database, and how to interact with the MySQL server. This chapter moves on to the lingua franca of databases: SQL.

SQL, short for Structured Query Language, is a group of special words used exclusively for interacting with databases. SQL is surprisingly easy to learn and use, and yet, amazingly powerful. In fact, ...

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