O'Reilly logo

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

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

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