MySQL Reference Manual

MySQL Reference Manual, 9780596002657 (0596002653), O'Reilly, 2002

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.

Comments

Amazing Books

SQL Pocket Guide (Pocket Guides)

O'Reilly, 2010

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2,...

Warfare and Weaponry in Dynastic Egypt

Pen and Sword, 2017

Defence. Attack. Symbolism. The development of warfare in any society provides an evocative glance into the lives (and deaths) of our predecessors. This is never more the case than with that most enticing of ancient civilizations, Ancient Egypt. Follow Rebecca Dean through the fascinating world of mysterious figures such as...

Java Message Service API Tutorial and Reference: Messaging for the J2EE Platform

Prentice Hall, 2002

Aimed at the more experienced Java developer who needs to work with enterprise messaging, Java Message Service API Tutorial and Reference delivers starter code and a complete reference to all JMS classes that you will need to know to work effectively with this powerful feature of the J2EE platform.

The no-nonsense, just-the-facts...

Microsoft System Center 2012 Unleashed

Sams Publishing, 2012

This is the definitive real-world guide to Microsoft System Center 2012, Microsoft’s newest and most powerful version of System Center. Authored by consultants who’ve deployed System Center in hundreds of enterprises and innovative smaller businesses, this book brings together up-to-the-minute tips, tricks, and...

Multimodal Usability (Human-Computer Interaction Series)

Springer, 2009

This preface tells the story of how Multimodal Usability responds to a special challenge. Chapter 1 describes the goals and structure of this book.

The idea of describing how to make multimodal computer systems usable arose in the European Network of Excellence SIMILAR – “Taskforce for creating human-machine...

Mathematical Fallacies and Paradoxes

Dover Publications, 1997

Stimulating, thought-provoking analysis of a number of the most interesting intellectual inconsistencies in mathematics, physics and language. Delightful elucidations of methods for misunderstanding the real world of experiment (Aristotle™s Circle paradox), being led astray by algebra (De Morgan™s paradox) and other mind-benders. Some...