MySQL Reference Manual

( 2 )

Overview

MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference ...

See more details below
Paperback (1ST)
$35.98
BN.com price
(Save 28%)$49.99 List Price
Other sellers (Paperback)
  • All (26) from $1.99   
  • New (5) from $30.81   
  • Used (21) from $1.99   
Sending request ...

Overview

MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.

Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL. In addition, you can turn a page and find such unexpected riches as:

  • A thorough comparison of MySQL with SQL standards and other databases
  • A discussion of privileges and suggested uses of privileges to enhance security
  • Directions for replicating a database and for running several MySQL servers on a single system
  • Directions for initializing a database from a flat file
  • Guidelines for estimating the performance of different queries
  • A far-reaching discussion of optimization, with reference to the implementation of MySQL
  • Investigations of the differences between data types and the pros and cons of each type of number, string, or timestamp
  • An extended inquiry into the effects of using delayed inserts
  • A candid explanation of why various errors occur and how to recover from them
  • Tips for weighted, full-text searches
  • Detailed descriptions of the features, strengths, and weaknesses of available table formats
  • A guide to adding new functions to MySQL

No serious MySQL user should be without this book.

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
With the highly anticipated release of MySQL 4.01 comes the official companion reference manual, direct from MySQL cofounder Michael (Monty) Widenius and the gang at MySQL AB. Whatever else you read about MySQL, this is the foundation resource you need first.

MySQL Reference Manual is nothing if not authoritative -- but unlike some “official” guides, it never sacrifices candor (or the developers’ strong viewpoints about transactions and other matters). You’ll find insider’s explanations of why MySQL errors occur and how to avoid and recover from them; as well as the best guidance available for optimizing performance (including insights into MySQL’s design limitations and trade-offs, and practical information for benchmarking).

The authors walk you through MySQL installation under Linux and Windows; basic database creation, connections, and queries; using MySQL with Apache; configuration; user accounts; and security (including using SSL to protect the mysqld server daemon process, not just traffic between browsers and servers). You’ll find detailed coverage of disaster prevention/recovery; replication; and MySQL’s library of administration tools and scripts. Along the way, the authors introduce each significant new feature, including bulk INSERTs; searching on packed indexes; creation of FULLTEXT indexes; row-level locking; the newly added UNION SQL statement; multi-table DELETEs; and more.

MySQL keeps getting more robust, more full-featured, and more flexible -- both from a technical and licensing standpoint. If you want to make the most of it, start right here. (Bill Camarda)

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.

Read More Show Less

Product Details

  • ISBN-13: 9780596002657
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 6/1/2002
  • Edition description: 1ST
  • Edition number: 1
  • Pages: 816
  • Sales rank: 1,161,938
  • Product dimensions: 6.66 (w) x 9.62 (h) x 1.43 (d)

Meet the Author

David Axmark, Co-founder: David Axmark is one of the founders of MySQL and worked with the product well before it had a name. He has worked as a consultant and software developer for nearly 20 years. Interested in free software since the early '80s, David has been committed to developing a successful business model through open source software.

Read More Show Less

Table of Contents

Preface

Chapter 1: General Information

Chapter 2: MySQL Installation

Chapter 3: Tutorial Introduction

Chapter 4: Database Administration

Chapter 5: MySQL Optimisation

Chapter 6: MySQL Language Reference

Chapter 7: MySQL Table Types

Chapter 8: MySQL APIs

Chapter 9: Extending MySQL

Problems and Common Errors

Contributed Programs

Credits

Porting to Other Systems

Environment Variables

MySQL Regular Expressions

Colophon

Read More Show Less

Customer Reviews

Average Rating 5
( 2 )
Rating Distribution

5 Star

(2)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted December 17, 2005

    Dhiraj Patra's review

    It is really a very good reference for freshers as well as experience developer in this field. Though writer should take care of new features like procedure, trigger etc. Best regards.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 14, 2002

    All the key mySQL info in one place

    Although this book is simply a compendium of all the mySQL documentation you can find online, the excellent index and the logical arrangement make it a pleasure to use. I almost always like to have a real book handy while programming and this book thoroughly covers both SQL syntax and the mySQL utilities, language extensions and related things nicely. Pricey, but convenient.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)