Page 66 - Code Craft Computer-8

CREATING A TABLE IN THE DATABASE

Creating a database is only the first step of data storage and management. You need to create a
table within the database, as it is the table that stores all the records within its rows and columns.
Once a database is created, the phpMyAdmin window looks like this:

1. Add the name of the table and number of columns/ fields the table will have.
2. Click on the Create button to finish the process.

Defining the Table Structure

To define the table structure, follow these steps:
1. Now, add the name of the field in the Name text field as Emp_ID , Department , Name and

Address.
2. Add the data type (type of values) for the fields, like name can store text (VARCHAR)
values, class can store integer (INT) values, so on.

66