Sams Teach Yourself PHP, MySQL® and Apache All in One, Fifth Edition

Chapter 16. Learning Basic SQL Commands

In this chapter, you learn the following:

• The basic MySQL data types

• How to use the CREATE TABLE command to create a table

• How to use the INSERT command to enter records

• How to use the SELECT command to retrieve records

• How to use basic functions, the WHERE clause, and the GROUP BY clause in SELECT expressions

• How to select from multiple tables, using JOIN or subselects

• How to use the UPDATE and REPLACE commands to modify existing records

• How to use the DELETE command to remove records

• How to use string functions built in to MySQL

• How to use date and time functions built in to MySQL

The preceding chapter explained the basics of the database design process, and this chapter provides ...