O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Relational schema in PDF

In Chapter 11, we defined relations between the book and the author tables. These relations were used for various foreign key functions (for example, getting a list of possible values in Insert mode). We will now examine a feature that enables us to generate a custom-made relational schema for our tables in the popular PDF format. This feature requires that the linked-tables infrastructure be properly installed and configured, as explained in Chapter 11.

Adding a third table to our model

To get a more complete schema, we will now add another table, country, to our database. Here is its export file:

CREATE TABLE IF NOT EXISTS `country` ( `code` char(2) NOT NULL, `description` varchar(50) NOT NULL, PRIMARY KEY (`code`) ) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required