Apress Cyber Monday SALE
  • eBook Price: $34.99 $10.00
  • Print Book Price: $49.99
Buy eBook Buy Print Book

Pro MySQL Cover Image

Whether you are a seasoned MySQL user looking to take your skills to the next level, or you're a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-59059-505-3
  • 768 Pages
  • User Level: Beginner to Advanced
  • Publication Date: July 26, 2005
  • Available eBook Formats: PDF

Related Titles

  • Pro Couchbase Server
  • OpenStack Trove
  • Common Lisp Recipes
  • Scalable Big Data Architecture
  • Introducing Gradle
  • The Definitive Guide to MongoDB: Third Edition
  • Pivotal Certified Spring Web Application Developer Exam
  • Beginning the Linux Command Line, Second edition
  • Using Scribe Insight
  • Introducing SQLite for Mobile Developers
Full Description

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world’s most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL’s advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won’t find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examplesfrom dealing with hierarchical data to performing geographic information system (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.

The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You’ll also learn about the new data dictionary features available in MySQL 5.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

On page 356:

DECLARE is not a reserve word in server ver 5.0.77 I can't seem to find out how you declare internal variables.... Please let me know if i'm mistaken...


    1. PHP Objects, Patterns, and Practice

      $38.99 $10.00

      View Book

    2. Beginning Android 3D Game Development

      $34.99 $10.00

      View Book

    3. Troubleshooting Oracle Performance

      $41.99 $10.00

      View Book

    4. Beginning Amazon Web Services with Node.js

      $38.99 $10.00

      View Book