Web Design

(Nancy Kaufman) #1

298


Create a Table ......................................................


The database page loads.
3 Type a name for the table
you want to create.
4 Type the number of fields
you want to add to your
table.
5 Click Go.

1 Open the phpMyAdmin page.


Note: See the previous section
for instructions on opening
phpMyAdmin.


2 Click the name of your
database.

Create a Table


O


nce you have created your database, you must populate it with tables. Tables make up the core
of your database; they are where your data is actually stored. Tables are made up of rows of
fields. Each field represents a distinct piece of your data. The data type is the kind of information
that can be stored in a field. The most common are the variable-length character field, the fixed-
length character field, integers, floating-point or decimal numbers, dates and times, and Boolean or
true-false. You need to specify the name and data type for each field you create.

1


2


3 4 5

Free download pdf