Creating the Sample Tables


Before moving on to the next lesson, you need to create the sample database tables that are used in this book.

Installing the Sample Tables

You can download a SQL file that contains all the instructions needed to create the sample tables from www.samspublishing.com.

Save this file to your hard disk as sampdb.sql and issue the following command:

 $ mysql - -user=yourname - -password dbname < sampdb.sql 


The < symbol causes the contents of sampdb.sql to be passed to the mysql program all at once. The result is that the sample tables are created within the database you specified.




Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net