Databases Reference
In-Depth Information
Using the same techniques used when creating the first table, we get:
Since we have three fields or less, the display is now in vertical mode (more details
on this in Chapter 6,
Vertical Mode
section).
Here the field name
id
, which is our primary key in this new table, relates to the
author_id
field from the
topic
table. After saving the table structure, we enter some
data for authors 1 and 2. Use your imagination for this!
Summary
In this chapter, we explained how to create a database and tables, and how to enter
data manually in the tables. We also saw how to confirm the presence of data by
using the browse mode; including the SQL query links, navigation bar, sorting
options, and row marking.
Search WWH ::
Custom Search