Master your Minecraft

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Tour our stores

    Recently Viewed clear list

    Best Books of the Year | December 10, 2014

    Mary Jo Schimelpfenig: IMG Best Fantasy/Sci-Fi of 2014

    Here are the books that knocked my socks off in 2014. All of them would make great gifts; each of them was truly something that evoked that... Continue »

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

MySQL Reference Manual: Documentation from the Source


MySQL Reference Manual: Documentation from the Source Cover


Synopses & Reviews

Publisher Comments:

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


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.

About 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.

Table of Contents

PrefaceChapter 1: General InformationChapter 2: MySQL InstallationChapter 3: Tutorial IntroductionChapter 4: Database AdministrationChapter 5: MySQL OptimisationChapter 6: MySQL Language ReferenceChapter 7: MySQL Table TypesChapter 8: MySQL APIsChapter 9: Extending MySQLProblems and Common ErrorsContributed ProgramsCreditsPorting to Other SystemsEnvironment VariablesMySQL Regular ExpressionsColophon

Product Details

Widenius, Michael
Axmark, Davis
Axmark, David
Arno, Kaj
DuBois, Paul
O'Reilly Media
Sebastopol, CA
Programming Languages - General
Programming Languages - SQL
Database Management - General
Client-server computing
Sql (computer program language)
Client-Server Computing - General
Database design
Edition Number:
1st ed.
Edition Description:
Print PDF
Series Volume:
Publication Date:
9.19 x 7 x 1.43 in 2.51 lb

Other books you might like

  1. MySQL Cookbook
    Used Trade Paper $11.95
  2. Core Mysql Used Trade Paper $4.95
  3. MySQL Crash Course New Trade Paper $31.50
  4. Microsoft SQL Server 2000... Used Trade Paper $1.00
  5. The Definitive Guide to MySQL 5, 3rd... New Trade Paper $49.99
  6. Programming Perl 2ND Edition Used Trade Paper $16.95

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Client Server
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

MySQL Reference Manual: Documentation from the Source New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 816 pages O'Reilly & Associates - English 9780596002657 Reviews:
"Synopsis" by ,
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.
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at