In order to follow along with the examples, you need a set of populated tables. Everything you need to get up and running can be found on this book's web page at http://www.forta.com/books/0672327120/. The web page contains two SQL script files that you may download:
Note For MySQL Only The SQL statements in the downloadable .sql files are very DBMS specific, and are designed to be used only with MySQL. The scripts have been tested extensively with MySQL 4.1 and MySQL 5 and have not been tested with earlier versions of MySQL. After you have downloaded the scripts, you can use them to create and populate the tables needed to follow along with the chapters in this book. Here are the steps to follow:
And with that you should be good to go! Note Create, Then Populate You must run the table creation scripts before the table population scripts. Be sure to check for any error messages returned by these scripts. If the creation scripts fail, you will need to remedy whatever problem might exist before continuing with table population. |