Databases Reference
In-Depth Information
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `country` (`code`, `description`) VALUES
('ca', 'Canada'),
('uk', 'United Kingdom');
We will link this table to the
author
table. Firstly, in
Relation view
for the
country
table, we specify the field that we want to display:
Then, we add a
country_code
column to the
author
table, and in the Relation view,
we link it to the newly created
country
table. We must remember to click
Go
for the
relation to be recorded. For this example, it is not necessary to enter any country data
for an author, as we are interested only in the relational schema.
Editing PDF Pages
Each relational schema is called a
page
. We can create or edit a page by clicking
Edit
PDF pages
in the
Operations
sub-page of the Database view.
Search WWH ::
Custom Search