Our screen now looks like this:
At this point, we could change the table type using the Type drop-down menu, but
for now we will just accept the default type.
Now we are ready to create the table by clicking on Save. If all goes well, the next
screen confirms that the table has been created; we are now in the Structure sub-page
of Table view.
If we forget to specify a value in the Length column for a CHAR or VARCHAR,
phpMyAdmin would remind us before trying to create the table.
Of the various tabs leading to other sub-pages, some are not active, because it
would not make sense to browse or search a table if there are no rows in it. It would,
however, be acceptable to export, because we can export a table's structure even if it
contains no data.
First Steps
[ 72 ]
Manual Data Insertion
Now that we have a table, let's put some data in it manually. Before doing so, here
are some useful references on data manipulation within this book:
Chapter 5 explains how to change data.
Chapter 8 explains how to import data from existing files.
Chapter 10 explains how to copy data from other tables.
Chapter 11 explains the relational system (in our case, we will want to link to
the author table).
For now, click on the Insert link, which will lead us to the data-entry (or edit) panel
(shown in the screenshot that follows).
Pages:
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93