Beginning MySQL.pdf

Beginning MySQL®

Robert Sheldon and Geoff Moes

TEAM LinG - Live, Informative, Non-cost and Genuine !

Beginning MySQL®

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Published simultaneously in Canada

ISBN: 0-7645-7950-9

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

1B/RW/QT/QV/IN

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any

means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections

107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or

authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood

Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be

addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317)

572-3447, fax (317) 572-4355, e-mail: brandreview@wiley.com.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO

REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE

CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT

LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED

OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED

HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE

UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR

OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A

COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE

AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION

OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF

FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE

INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY

MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY

HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services or to obtain technical support, please contact our

Customer Care Department within the U.S. at (800) 762-2974, outside the U.S. at (317) 572-3993 or fax (317)

572-4002.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be

available in electronic books.

Library of Congress Cataloging-in-Publication Data

Sheldon, Robert, 1955-

Beginning MySQL / Robert Sheldon and Geoff Moes.

p. cm.

Includes bibliographical references and indexes.

ISBN 0-7645-7950-9 (paper/website : alk. paper)

1. SQL (Computer program language) 2. MySQL (Electronic resource) I. Moes, Geoff, 1963- II. Title.

QA76.3.S67S54 2005

005.75'65--dc22

2004031058

Trademarks: Wiley, the Wiley Publishing logo and related trade dress are trademarks or registered trademarks of

John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without

written permission. MySQL is a registered trademark of MySQL AB Limited Company. All other trademarks are

the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or vendor

mentioned in this book.

TEAM LinG - Live, Informative, Non-cost and Genuine !

About the Authors

Robert Sheldon

Robert Sheldon’s MySQL programming is rooted in ten years of experience working with SQL, as it is

implemented not only in a MySQL environment, but also within SQL Server, Microsoft Access, and Oracle

environments. He has programmed with SQL directly through database interfaces and script files and

indirectly through PHP, JSP, ASP, and ASP.NET applications that connected to various databases

and issued SQL statements. Robert has also managed the maintenance and development of Web sites and

online tools, which has included performing project analysis, developing functional specifications,

and managing database and Web development. He has designed and implemented various Microsoft

Access, SQL Server, and MySQL databases, as well as developed and implemented a variety of Web-based

solutions. In all these roles, he has had to perform numerous types of ad hoc queries and modifications,

build databases, create and modify database objects, create and review embedded statements, and

troubleshoot system- and data-related problems.

In addition to having a technical and SQL background, Robert has written or co-written nine books on

various network and server technologies, including two that have focused on SQL Server design and

implementation, one on SQL programming (based on the SQL:1999 standard), and one on Microsoft

Office Access 2003. The books that Robert has written contain training material that is designed to teach

users specific skills and to test their knowledge of the material covered. Having contracted as the senior

developmental editor for the Microsoft certification team, he brought to these books his experience devel-

oping exam items that helped to focus readers on the skills necessary to perform specific tasks. Robert

has also written and edited a variety of other documentation related to SQL databases and other computer

technologies. He works as an independent technical consultant and writer in the Seattle area.

Geoff Moes

Geoff Moes is a software architect and developer who has designed and implemented databases in

MySQL as well as having designed and implemented software systems in PHP, Java/J2EE, and ASP.NET

that have utilized MySQL databases through various database connectivity interfaces. Geoff received his

bachelor’s degree in Computer Science from Virginia Tech and has worked in the software industry for

18 years. He specializes in software and database architecture and development as it relates to Web-

based systems. He has worked with several database products in addition to MySQL, including SQL

Server, DB2, and Oracle. He has also developed a variety of software applications that have connected to

various databases using several different languages and platforms including Java J2EE/JDBC/EJB,

C++/ODBC, and ASP.NET/ODBC/OLEDB.

Geoff’s publishing credits include “Passing Arrays Between Jscript and C++” (September 7, 2000,

ASPToday.com, under WROX) and three articles published in Windows & .NET Magazine (online):

“Common Internet Hacker Attacks” (December 1, 1998), “Remote Web Administration, Part 2”

(November 1, 1998), and “Remote Web Administration, Part 1” (October 1, 1998). Geoff works as an

independent software consultant in the Washington D.C. metro area. When he is not in front of the

keyboard, he enjoys photography, mountain biking, hiking, and international travel.

TEAM LinG - Live, Informative, Non-cost and Genuine !

Credits

Acquisitions Editor

Debra Williams Cauley

Vice President and Publisher

Joseph B. Wikert

Development Editor

Brian Herrmann

Project Coordinator

Erin Smith

Technical Editor

David Mercer

Quality Control Technician

Brian H. Walls

Copy Editor

Nancy Hannigan

Text Design and Composition

Wiley Composition Services

Editorial Manager

Mary Beth Wakefield

Proofreading and Indexing

TECHBOOKS Production Services

Vice President & Executive Group Publisher

Richard Swadley

Acknowledgments

As with any publication, too many people were involved in the development of Beginning MySQL to

name them all, but we would like to acknowledge those who we worked with the closest in order to

complete this project in a timely manner (and with our sanity still somewhat intact). Our special thanks

goes to Debra Williams-Cauley, the acquisitions editor at John Wiley & Sons, Inc., who pulled this project

together in such a professional and responsive manner. And we particularly want to thank Brian Herrmann,

the development editor on this book who patiently and efficiently (and pleasantly, we might add) kept

this project moving forward, while always paying attention to details and answering our never-ending

stream of questions. We also want to acknowledge David Mercer, the technical editor, for his grasp of the

subject matter and his invaluable input into the book. In addition, we want to acknowledge all the edi-

tors, proofreaders, indexers, designers, illustrators, and other participants whose efforts made this book

possible. Finally, we want to thank our agent, Margot Maley Hutchison, at Waterside Productions, Inc.,

for her help in moving forward on this project and for tending to all the details.

TEAM LinG - Live, Informative, Non-cost and Genuine !

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: