Chapter 16. Learning Basic SQL Commands

Having just learned the basics of the database design process, this chapter provides a primer on the core SQL syntax, which you will use to create and manipulate your MySQL database tables. This is a very hands-on chapter, and it assumes that you are able to issue queries through the MySQL monitor on Windows or Linux/Unix. Alternatively, if you use a GUI to MySQL, this chapter assumes you know the methods for issuing queries through those interfaces. Please note, this may not be the most exciting chapter in the book, but it will show you many, many functional examples of elements you’ll use throughout the rest of your work.

In this chapter, you will learn

  • The basic MySQL datatypes

  • How to use the CREATE TABLE ...

Get Sams Teach Yourself PHP, MySQL® and Apache All in One, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.