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

Get Practical PHP and MySQL Website Databases: A Simplified Approach now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial