O'Reilly logo

Mastering phpMyAdmin 3.3.x 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

Generating relational schemas in PDF

In Chapter 10, Benefiting from the Relational System, we defined relations between the book and 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 10,Benefiting from the Relational System.

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` ...

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