Its default value of 1000 should
be a good balance between seeing too few and seeing too much of the queries,
especially when doing large imports.
It is important to examine the phpMyAdmin feedback to ascertain the validity of the
operations we make through the interface. This way, we can detect errors like typos
in the names, or creation of a table in the wrong database.
??? ??? ???
???
First Steps
[ 68 ]
Creating Our First Table
Now that we have a new database, it's time to create a table in it. The example table
we will use is the familiar book table.
Choosing the Fields
Before creating a table, we should plan the information we want to store. This is
usually done during database design. In our case, a simple analysis leads us to the
following book-related data we want to keep:
International Standard Book Number (ISBN)
Title
Number of pages
Author identification
For now, it is not important to have the complete list of fields (or columns) for our
book table; we will modify it by prototyping the application and refine it later. At the
end of the chapter, we will add a second table, author, containing information about
each author.
Table Creation
We have chosen our table name and we know the number of fields. We enter this
information in the Create new table dialog and click Go to start creating the table:
We then see a panel specifying field information.
Pages:
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90