Preface [ ] Chapter 6 covers a supplemental
Preface [ ] Chapter 6 covers a supplemental case study about an airline system. This case study involves various steps such as gathering documents, preparing preliminary list of data elements, preparing a list of tables, sample values, and queries for the airline system. What You Need for This Book Basic knowledge of SQL is required. Emphasis is made on the phpMyAdmin web-based interface for reproducing the examples, although the “mysql” command- line tool can be used. No knowledge of MySQL server administration or any specific operating system is required. 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, `description` char(40) NOT NULL, PRIMARY KEY (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `event` VALUES (1, ‘washed’);
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check Vision mysql hosting services