Databases Reference
In-Depth Information
As we have three columns or less, the display is now in vertical mode (refer to the
Vertical
mode
section in
Chapter
5
for more details).
The column name
id
, which is our primary key in this new table, relates to the
author_id
column from the
topic
table. After saving the table structure, we enter
some data for authors 1 and 2. Use your imagination for this!
Summary
This chapter explained how to create a database and tables, and how to enter data
manually in the tables. It also covered how to confirm the presence of data by using
the browse mode, which includes the SQL query links, navigation bar, sorting
options, and row marking.
The next chapter explains how to edit data rows and covers the various aspects of
deletion of rows, tables, and databases.
Search WWH ::
Custom Search