Learn basic SQL commands

This sample chapter, taken from Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition, teaches you the basics of SQL, from table creation to manipulating records.

Learn the core SQL syntax for creating and manipulating MySQL database tables.

This sample chapter, taken from Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition, discusses some basic SQL commands. The chapter covers the following topics:

• The basic MySQL datatypes
• 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 select from multiple tables, using JOIN
• 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 into MySQL
• How to use date and time functions built into MySQL

Title: Sams Teach Yourself PHP, MySQL and Apache All in One, 2nd Edition
ISBN: 0672327252
Published: December 2004
Author: Julie Meloni
Chapter: Chapter 16: Learning Basic SQL Commands
Published by Sams