Databases Reference
In-Depth Information
The MIME column is empty until we add MIME-related information to some
columns. (This is explained in Chapter 16.)
Relational Schema in PDF
In Chapter 11, we defined relations between the books and authors tables. These
relations were used for various foreign key functions (for example, getting a list of
possible values in Insert mode). Now we will examine a feature that enables us to
generate a custom-made relational schema for our tables in a popular format: PDF.
Adding a Third Table to Our Model
To get a more complete schema, we will now add another table, the countries table,
to our database. Here is its export file:
CREATE TABLE 'countries' (
'country_code' char(2) NOT NULL default '',
'description' varchar(50) NOT NULL default '',
PRIMARY KEY ('country_code')
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO 'countries' ('country_code', 'description') VALUES ('ca',
'Canada');
 
Search WWH ::




Custom Search