O'Reilly logo

Practical PHP and MySQL Website Databases: A Simplified Approach by Adrian W. West

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 1

image

Create and Test a MySQL Database and Table

This chapter introduces the concept of a database and a practical way of testing it. Using the projects, you will create a MySQL database and a table. As you work through the projects, you will become familiar with the phpMyAdmin interface.

This chapter has the following main sections:

  • Definitions
  • The free tool for developing and maintaining interactive databases
  • Using phpMyAdmin to create a database and a table
  • Exploring SQL
  • Deleting databases, tables, and rows.

Defining the Term Database

Databases can be used to store products, details of customers, records of members of a society or a ...

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