Copyright © 2004 by Pearson Education, Inc.
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Pearson cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.
MySQL and the MySQL logo are trademarks or registered trademarks of MySQL AB and are used here by permission.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an “as is” basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.
Bulk Sales
Pearson offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact
U.S. Corporate and Government Sales
1-800-382-3419
[email protected]
For sales outside of the U.S., please contact
International Sales
1-317-428-3341
[email protected]
ASSOCIATE PUBLISHER
Mark Taber
ACQUISITIONS EDITOR
Shelley Johnston
DEVELOPMENT EDITOR
Damon Jordan
MANAGING EDITOR
Charlotte Clapp
SENIOR PROJECT EDITOR
Matthew Purcell
COPY EDITOR
Cheri Clark
INDEXER
Sharon Shock
PROOFREADER
Tonya Fenimore
TECHNICAL EDITORS
Zak Greant
J. Scott Johnson
Chris Newman
MARKETING MANAGER
Randi Roger
COVER & INTERIOR DESIGNER
Gary Adair
PUBLISHING COORDINATOR
Vanessa Evans
MySQL® Press is the exclusive publisher of technology books and materials that have been authorized by MySQL® AB, the company that develops and markets the MySQL database. MySQL Press books are written and reviewed by the world’s leading authorities on MySQL technologies, and are edited, produced, and distributed by the Que/Sams Publishing group of Pearson Education, the worldwide leader in integrated education and computer technology publishing. For more information on MySQL Press and MySQL Press books, please go to www.mysqlpress.com.
MYSQL HQ
MySQL AB
Bangårdsgatan 8
S-753 20 Uppsala
Sweden
UNITED STATES
MySQL Inc.
2510 Fairview Avenue East
Seattle, WA 98102
USA
GERMANY, AUSTRIA AND SWITZERLAND
MySQL GmbH
Schlosserstraβe 4
D-72622 Nürtingen
Germany
FINLAND
MySQL Finland Oy
Tekniikantie 21
FIN-02150 Espoo
Finland
FRANCE
MySQL AB (France)
123, rue du Faubourg St. Antoine
75011, Paris
France
MySQL® AB develops, markets, and supports a family of high-performance, affordable database servers and tools. With headquarters in Sweden, and with offices and employees located throughout the world, MySQL’s mission is to make superior data management available and affordable for all and to contribute to building mission-critical, high-volume systems and products worldwide. MySQL AB is the sole owner of the MySQL server source code, the MySQL trademark, and the mysql.com domain. For more information on MySQL AB and MySQL AB products, please go to www.mysql.com.
Dedication
This book is dedicated to our families: both the human and four-legged members.