MySQL Administrators Guide and Language Reference (2nd Edition)

MySQL® Administrator's Guide and Language Reference

Copyright © 2006 by MySQL AB

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.

Library of Congress Catalog Card Number: 2005934932

Printed in the United States of America

First Printing: April 2006

09 08 07 06 4 3 2 1

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Pearson Education 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.

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 author 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 or from the use of the CD or programs accompanying it.

Bulk Sales

Pearson Education 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

     corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact     International Sales

     international@pearsoned.com

ASSOCIATE PUBLISHER

Mark Taber

ACQUISITIONS EDITOR

Shelley Johnston

DEVELOPMENT EDITOR

Damon Jordan

MANAGING EDITOR

Charlotte Clapp

PROJECT EDITOR

Andy Beaster

INDEXER

Heather McNeill

PROOFREADER

Mike Henry

PUBLISHING COORDINATOR

Vanessa Evans

MULTIMEDIA DEVELOPER

Dan Scherf

DESIGNER

Gary Adair

PAGE LAYOUT

Bronkella Publishing

MySQL® Press is the exclusive publisher of technology books and materials that have been authorized by MySQL AB. 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 ABBanagårdsgatan 8S-753 20 UppsalaSweden

GERMANY, AUSTRIA, ANDSWITZERLANDMySQL GmbHRadlkoferstrasse 281373 M¨nchen

Germany

FRANCEMySQL AB (France)123, rue du Faubourg St. Antoine

75011, Paris

France

UNITED STATESMySQL Inc.2510 Fairview Avenue East

Seattle, WA 98102

USA

FINLAND

MySQL Finland AbLaaksotie/Dalvägen 10

02700 Kaunianen/Grankulla

Finland

MySQL® AB develops and supports a family of high-performance, affordable database productsincluding MySQL Network, a comprehensive set of certified software and premium support services. MySQL AB is the sole owner of the MySQL server source code, the MySQL trademark, and the mysql.com domain. For more MySQL information and downloads, please visit www.mysql.com.

  • Training information: www.mysql.com/training

  • Support services: www.mysql.com/support

  • Consulting services: www.mysql.com/consulting

Категории