O'Reilly logo

Sams Teach Yourself PHP, MySQL by Julie C. 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

The previous chapter explained the basics of the database design process and 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 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 functional examples of elements you’ll use throughout the rest of your work.

In this chapter, you will learn

  • The basic MySQL data types

  • How to use the CREATE ...

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