Creating your MySQL Database: Practical Design Tips and Techniques

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

There are three styles for code. Code words in text are shown as follows: "In this case, we can add employee information, the employee code to the car_event table".

A block of code will be set as follows:

CREATE TABLE `event` (
`code` int(11) NOT NULL,
`description` char(40) NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `event` VALUES (1, 'washed');

When we wish to draw your attention to a particular part of a code block, the relevant lines or items will be made bold:

CREATE TABLE `event` ( `code` int(11) NOT NULL, ...