e99 Online Shopping Mall

Geometry.Net - the online learning center Help  
Home  - Computer - Mysql (Books)

  1-20 of 100 | Next 20

click price to see details     click image to enlarge     click link to go to the store

1. MySQL (4th Edition)
2. High Performance MySQL: Optimization,
3. PHP and MySQL Web Development
4. Learning PHP, MySQL, and JavaScript:
5. PHP 6 and MySQL 5 for Dynamic
6. MySQL 5.0 Certification Study
7. MySQL High Availability: Tools
8. Learning MySQL
9. Head First PHP & MySQL
10. PHP & MySQL For Dummies, 4th
11. MySQL Pocket Reference: SQL Functions
12. MySQL Crash Course
13. Beginning PHP and MySQL: From
14. MySQL Administrator's Bible (Bible
15. MySQL Cookbook
16. MYSQL in a Nutshell (In a Nutshell
17. MySQL Stored Procedure Programming
18. PHP & MySQL Web Development
19. Understanding MySQL Internals
20. MySQL Tutorial

1. MySQL (4th Edition)
by Paul DuBois
Paperback: 1224 Pages (2008-09-08)
list price: US$49.99 -- used & new: US$27.48
(price subject to change: see help)
Asin: 0672329387
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1


MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications.


In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers.


The fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1.


“One of the best technical books I have read on any subject.”

–Gregory Haley, C Vu, The Association of C & C++ Users


“A top-notch user’s guide and reference manual, and in my opinion, the only book you’ll need for the daily operation and maintenance of MySQL databases.”

–Eugene Kim, Web Techniques


Introduction 1


Part I: General MySQL Use

Chapter 1: Getting Started with MySQL 13

Chapter 2: Using SQL to Manage Data 101

Chapter 3: Data Types 201

Chapter 4: Stored Programs 289

Chapter 5: Query Optimization 303


Part II: Using MySQL Programming Interfaces

Chapter 6: Introduction to MySQL Programming 341

Chapter 7: Writing MySQL Programs Using C 359

Chapter 8: Writing MySQL Programs Using Perl DBI 435

Chapter 9: Writing MySQL Programs Using PHP 527


Part III: MySQL Administration

Chapter 10: Introduction to MySQL Administration 579

Chapter 11: The MySQL Data Directory 585

Chapter 12: General MySQL Administration 609

Chapter 13: Access Control and Security 699

Chapter 14: Database Maintenance, Backups, and Replication 737


Part IV: Appendixes

Appendix A: Obtaining and Installing Software 777

Appendix B: Data Type Reference 797

Appendix C: Operator and Function Reference 813

Appendix D: System, Status, and User Variable Reference 889

Appendix E: SQL Syntax Reference 937

Appendix F: MySQL Program Reference 1037


Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book.

Appendix G: C API Reference 1121

Appendix H: Perl DBI API Reference 1177

Appendix I: PHP API Reference 1207


Index 1225


Amazon.com Review
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn't "free" about MySQL (the application) is its server's commercial use; all clients and noncommercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its value and the value of its namesake.

The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)

The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces.

Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.

Although it is nearly 800 pages in length, DuBois's book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application. --Peter Leopold ... Read more

Customer Reviews (120)

5-0 out of 5 stars Excellent Book
This book has been super useful.I was new to development with MySQL and among the 3 or 4 MySQL books I got, this is the go-to book I use.It's very thorough, explains things clearly, and has lots of concise examples to show statements in use.Highly recommend it.

4-0 out of 5 stars Good Book
I haven't had a chance to go through the entire book but based on what I have read so far all the information that I need to setup, maintain and access data through a MySQL database seems to be there. I would recommend this for folks new to MySQL.

5-0 out of 5 stars Top Notch book on MySql
Top Notch book on MySql.Clearest and best explanation of SQL I have ever read.

5-0 out of 5 stars Great resource
Great book, describes from Beginner to Moderate-advanced topics. This could be considered "the" manual for MySql.

5-0 out of 5 stars Good introduction, perfect reference
If you're looking for a book on MySQL, this is clearly the one. It's up-to-date for MySQL 5 (MySQL 6 is not yet ready for wide release), it effectively explains generic SQL concepts like inner/outer joins, and, of course, it's a comprehensive guide to the peculiarities of MySQL. Even if you're using MySQL through an abstraction layer, such as Hibernate, you'll still find the information on configuration useful. ... Read more

2. High Performance MySQL: Optimization, Backups, Replication, and More
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny D., Arjen Lentz, Derek J. Balling
Paperback: 712 Pages (2008-06-18)
list price: US$49.99 -- used & new: US$28.00
(price subject to change: see help)
Asin: 0596101716
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:

  • Emphasis throughout on both performance and reliability
  • Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
  • Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
  • A detailed discussion on how to build very large, highly scalable systems with MySQL
  • New options for backups and replication
  • Optimization of advanced querying features, such as full-text searches
  • Four new appendices
The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations. ... Read more

Customer Reviews (24)

3-0 out of 5 stars Worth the purchase
Great resource for learning the ins and outs of benchmarking a typical cms with a mysql db.

5-0 out of 5 stars The best book about creating software with High Aviability & Scalability in mind (not only using MySQL!)
This is just the best book I've read about creating software, that needs high availability and high scalability. You think, this is book is only about MySQL? Surprise! It's not, actually. Yes, some details apply only to MySQL, but common technical things such as data sharding, caching, clustering etc. can be applied to any software.

Reading this book I've learned like I read about 10 different books on the subject. Highly recommended! It's a pity there is no Russian translation available.

4-0 out of 5 stars Good book
Good book, with detailed explanations, but it could get more detailed (that's why only 4 stars and not 5).

4-0 out of 5 stars A good start point into high performance
It's a good start point into high performance tunning, but not a deep into every concept, which is not possible in a single book. The book dives into some benchmark, optimization of queries, the capabilities of every storage engine, and also its weaknesses, some compared backup strategies, replication, and master-slave configurations, all well explained, up to MySQL 5.1, but with new versions in mind. I enjoy this book, although some concerns are hard by nature, and some kind of query optimization could be more graphical to better understanding.

5-0 out of 5 stars Very useful... just very useful.
How come I did not comment on this book before? Its been some time since I got it, read it, and used it! That's what this book is... useful, very useful. We had to optimize a DB, specially a huge table with millions of numbers and managed to go from tens of seconds to milisecs. I would say it was.. well, very useful;) ... Read more

3. PHP and MySQL Web Development (4th Edition)
by Luke Welling, Laura Thomson
Paperback: 1008 Pages (2008-10-11)
list price: US$54.99 -- used & new: US$29.99
(price subject to change: see help)
Asin: 0672329166
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.


PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.


This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.


The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.



Amazon.com Review
The PHP server-side scripting language and the MySQL database management system (DBMS) make a potent pair. Both are open-source products--free of charge for most purposes--remarkably strong, and capable of handling all but the most enormous transaction loads. Both are supported by large, skilled, and enthusiastic communities of architects, programmers, and designers. PHP and MySQL Web Development introduces readers (who are assumed to have little or no experience with the title subjects) to PHP and MySQL for the purpose of creating dynamic Internet sites. It teaches the same skills as introductory Active Server Pages (ASP) and ColdFusion books--technologies that address the same niche.

Authors Luke Welling and Laura Thomson's technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes--"Accessing array contents" and "Using encryption with PHP" are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors' commentary on them take center stage.

For reference material on MySQL, have a look at Paul DuBois's MySQL. On the PHP side, Web Application Development with PHP 4.0 is excellent. --David Wall

Topics covered:

  • The MySQL database server (for both Unix and Windows)
  • Accessing MySQL databases through PHP scripting (the letters don't really stand for anything)
  • Database creation and modification
  • PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce
  • Authentication
  • Network connectivity
  • Session management
  • Content customization
... Read more

Customer Reviews (229)

5-0 out of 5 stars Excellent
I suggest getting a beginners PHP book before this because all it is in the beginning is a crash course, but everything after the first couple of chapters is right on the money! Very good book worth buying.

4-0 out of 5 stars Great reference book
This is a great reference book for PHP.The book arrived in great condition, looks like it was wasn't used.I can tell a college student owned it. :)

4-0 out of 5 stars From the Beginning
I come from a programming background and am not a professional web designer.However, some years ago I brought up a website written in Javascript and JSP running against an Oracle DB for an organization I belong to.I then dropped the programming end of things and just made minor changes to the website until recently when I was forced to redo the website in PHP and MySql, both of which I knew nothing about.So I bought this book together with the PHP Cookbook published by O'reilly. My foremost question was: "how can I learn this stuff with minimal brain damage without going through 1000 pages?".This book did the trick to introduce me to PHP & MySql in a couple of days.The chapters on designing major applications such as building a shopping cart quickly showed me how to put the various code pieces together into a coherent whole.However, when the rubber hit the road I ran into several problems.The major obstacle was in divining the pros and cons of using the Procedural vs Object Oriented paradigms.In many of the book's examples, both paradigms are used which was very confusing and caused me headaches getting my code to work.Once I told myself to settle on just the OO approach and ignore the Procedural approach things got much better, since I stopped confusing the two sets of syntax.I downgraded my rating 1 star because of this most irritating and time consuming confusion.The sections on security I found most helpful.As a book to orient a person to PHP and MySql I give it 5 stars.As a future reference, I also give it 5 stars.As a book to learn the nits and grits, I give it 3 stars......hence my overall rating of 4 stars.If I knew then what I know now, I'd still buy the book. I'm also writing a review of the PHP Cookbook.

5-0 out of 5 stars highly useful guide for PHP & MySQL
Bought it about a month ago. Havn't finish reading it all yet but i'm already able to write practical web sites. The book is well organized, written profesionaly and easy to follow (altough here and there minor editing are still required).

I had some background in programming (Java) and HTML which i belive made it alot easier to fully understand the first part: "using PHP". Had absolutely no background on MySQL and thanks to this book i have a good understanding of it.

Bottom line, couldn't ask for something else.
If you have basic background in programming, meaning, you already wrote some code lines, this book is the one for you!

5-0 out of 5 stars PHP and MySQL
The book is great to start programming in php.
Very recommended!
PHP and MySQL Web Development (4th Edition) ... Read more

4. Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites (Animal Guide)
by Robin Nixon
Paperback: 528 Pages (2009-07-14)
list price: US$39.99 -- used & new: US$25.01
(price subject to change: see help)
Asin: 0596157134
Average Customer Review: 4.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL, and JavaScript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add JavaScript to create rich Internet applications and websites.

Learning PHP, MySQL, and JavaScript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.

This book will help you:

  • Understand PHP essentials and the basics of object-oriented programming
  • Master MySQL, from database structure to complex queries
  • Create web pages with PHP and MySQL by integrating forms and other HTML features
  • Learn about JavaScript, from functions and event handling to accessing the Document Object Model
  • Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
  • Make Ajax calls and turn your website into a highly dynamic environment
  • Upload and manipulate files and images, validate user input, and secure your applications
... Read more

Customer Reviews (29)

4-0 out of 5 stars Why not Jquery, instead of YUI?
Seems like the perfect book for my college web programming course....
except Jquery is now used by 78% of the world (I saw this number on a
very recent review of web technologies.)So I wish the authors would
have use Jquery instead of YUI.Now my students will have to buy a
separate Jquery book.

1-0 out of 5 stars If you're a beginner, stay away from this book
As a beginner, I was looking for a book to introduce me to PHP, MYSQL, and Javascript. The idea behind the book is great, but the execution is abysmal. Especially when the programs written in the book are filled with errors. Page 233 specifically. The errata page on the website has the author saying that the code on page 233 in the book won't work, but not exactly why. But of course, the code he supplies on the errata page doesn't work either. As a novice, how in the world am I supposed to debug the author's programs! He evidently didn't do it himself, either.

This is just disgraceful. Were the people who gave this book great reviews, already well-versed in PHP, to be able to catch the errors.
Did the people who gave this book great reviews actually do the examples? Were they paid by the O'Reilly to give the book good reviews.

5-0 out of 5 stars Excellent Book --- Jam-Packed With Valuable Info
This is one of the best books I have ever read as far as how much information it contains and readability.Absolutely the best book for getting started in PHP, MySQL and JavaScript. I will be keeping this book and using it for reference for quite a while.Very highly recommended.

3-0 out of 5 stars Okay, but...
I bought this based on the reviews, and it was okay, but not great. The first few chapters were very helpful, but I had problems getting the examples to work, even when I pulled them from the publisher site. This book has great potential, and I did learn a lot from it, but was disappointed the further I got into it.

5-0 out of 5 stars Even the PHP Guru Recommends it
I've been teaching many people how to write PHP code at [...], and I have to say that this is one PHP book that is a great reference for learning PHP.

Although I didn't buy it through Amazon, a friend of mine showed me his, and I am actually quite impressed.

O'Reilly did a nice job with this one! ... Read more

5. PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
by Larry Ullman
Paperback: 648 Pages (2007-12-29)
list price: US$49.99 -- used & new: US$25.67
(price subject to change: see help)
Asin: 032152599X
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject. ... Read more

Customer Reviews (158)

2-0 out of 5 stars PHP 6???
When did PHP 6 get released? It is 2010 and the latest stable release of PHP is 5.3.x. Stick with Apress or O'Reilly publications.

1-0 out of 5 stars PHP 6 doesn't exist.
This book is for PHP 6 which... does't exist.The description says "PHP 6 (due out in 2008)."It didn't come out in 2008.It hasn't come out in 2010.No one knows when it will come out.This is a technical book about a non-existent technology.

5-0 out of 5 stars Great for beginners..so far..
So I'm actually in the process of going through this book. I thought I'd wait until I actually finish the book, but figure it'll be useful to give feedback while the process is still fresh.I'm barely on chapter 2 but honestly this book has been really easy to follow. I actually bought this book because of other ppls review on amazon, saying it's a great beginners book..and just as they said, this is a great beginners book.I have learned html, css and javascript..but besides that I've never had any programming skills or any experience with databases. This is a really simple to the point book, and Larry Ullman takes a very simple and casual approach. Making it a lot easier to follow than a cut and dry book.

From my experience so far, if you're completely new to this php and mysql stuff, this would be a good start. It is for me so far =)

2-0 out of 5 stars Messy Examples, Book Falls Apart
I used this book in college. The book isn't that bad but the examples can be hard to understand because the entire book has a "Two-Column" design. Basically, every page is split into two columns. Its hard to read code examples when they are split into different columns and then spread over different pages.

My book also split right in half in the center of the book. The binding came unglued and fell aprt. I contacted my college book store and they were going to replace it for me. Upon looking at the rest of the books on the shelf, the bookstore manager noticed that those books were also falling apart in the center.

It appears there are too many pages for a paperback book, and the book was not glued very well.

If you buy it, don't plan on it lasting very long.

5-0 out of 5 stars Excellent Read
I was simply looking for a book to teach me the basics of PHP and MYSQL. This book is amazing! It's just what I needed and I am already mastering php on page 50 of 600. Every day I work through this book and what would usually be a chore is really fun. The guided code tutorials and the way in which this book is teaching me is excellent, it's like having a personal tutor. This book is teaching me in a way in which I can understand and most importantly enjoy :D.

I must also mention that I tried using php and mysql for dummies but, it just doesn't compare in the way it teaches! I am a student, recommended to anyone wanting a future career as a web professional. It has screenshots, code comments and guided tutorials. ... Read more

6. MySQL 5.0 Certification Study Guide
by Paul DuBois, Stefan Hinz, Carsten Pedersen
Paperback: 643 Pages (2005-09-03)
list price: US$64.99 -- used & new: US$36.93
(price subject to change: see help)
Asin: 0672328127
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.


Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.


The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

... Read more

Customer Reviews (18)

4-0 out of 5 stars Good self-study resource
This book is a necessary but not entirely sufficient resource if you plan to complete the 5.x developer and/or DBA exams with self-study.Most of the subject areas present on the exams are covered in enough detail to easily pass if you are experienced with another database product and can apply that experience. (FYI, I have 15+ years working with Oracle/SQL Server and have dabbled with MySQL since 3.x, passed all 4 exams using this guide).

That said, you will likely need to supplement the book by reading the MySQL documentation if you wish to get as much knowledge as possible from the study process.Certainly try out each command on a test MySQL instance multiple times using version 5.x (NOT 5.1 where some behaviors have changed).

The practice questions provided are not all in multiple-choice format as you will encounter on the exam, which can be a good mental exercise for review, but the answer formats can be frustrating in some cases, as in the case of a multiple-choice question with five possible letter choices, wherein the answer is a paragraph that doesn't indicate the correct letter choices.Trivial but annoying.

Be sure you complete all practice questions from the accompanying CD and understand why your answers were right or wrong.There are no labs or practical exercises included, although a sample schema is included from which many of the practice questions are drawn.

If you are not taking the exams, this is still a good primer on MySQL.

4-0 out of 5 stars Learning MySql
If you need to learn MySql, this book is a very good choise, easy to understand, good and clear examples step by step, no just the query they show the query and the response from the server, not like another books that only show the query but don't show you the server response, you must guest or try and try.

5-0 out of 5 stars Nirdesh Mohan
I have been a J2EE Architect/developer using DB2/ORACLE for many years. I always feel that I am lacking in DB so I thought lets do DB certification and I chose mySQL. I have been using mySQL at home for my learning and in this book I found many interesting things that I was unaware. The book has every detail of topic that I need to prepare for the exam.

5-0 out of 5 stars It does exactly what it is for
The book is great not only to get certified, but also to learn about NySQL. It is written in such a manner that you need not to be experienced with the software (I advise you though, to be familiar with it prior to making an exam).

The book is great, CD examples are great, also comes with test evaluations. Only drawback is that the exams are expensive.

5-0 out of 5 stars Solid material for exam or not
This book is a very comprehensive guide to what MySQL offers and can teach you.

Would definitely recommend for anyone needing a great book about MySQL. ... Read more

7. MySQL High Availability: Tools for Building Robust Data Centers
by Charles Bell, Mats Kindahl, Lars Thalmann
Paperback: 624 Pages (2010-07-07)
list price: US$49.99 -- used & new: US$27.43
(price subject to change: see help)
Asin: 0596807309
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.

Written by engineers who designed many of the tools covered inside, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability -- knowledge that’s essential for any organization using this database system.

  • Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
  • Get techniques for improving response time and handling large data sets
  • Monitor database activity and performance, as well as major operating system parameters
  • Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
  • Automate key tasks with code from an open source library written by the authors
  • Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
  • Use MySQL Cluster to achieve high availability
"MySQL replication is widely deployed but has never been adequately explained. This book changes that." -- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies
... Read more

8. Learning MySQL
by Seyed M.M. (Saied) Tahaghoghi, Hugh Williams
Paperback: 618 Pages (2006-11-14)
list price: US$44.99 -- used & new: US$24.99
(price subject to change: see help)
Asin: 0596008643
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as:

  • Which are my top ten fastest-selling products?
  • How frequently does this person come to our facility?
  • What was the highest, lowest, and average score of the team last season?

MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and Learning MySQL provides all the tools you need to get started.This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.

After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.

Topic include:

  • Installation on Linux, Windows, and Mac OS X
  • Basic and advanced querying using SQL
  • User management and security
  • Backups and recovery
  • Tuning for improved efficiency
  • Developing command-line and web database applications using the PHP and Perl programming languages

The authors, Saied Tahaghoghi and Hugh E. Williams, have careers in academia and business, and share a keen interest in research into search technologies.

Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in Learning MySQL that will last a career.

... Read more

Customer Reviews (14)

5-0 out of 5 stars it was nice business deal
business experience with seller was good. there was not any kind of problem. book arrived in timely fashion.
I recommend doing business with this seller.

5-0 out of 5 stars 100% Recomendado
Soy de Mexico y la verdad es que la calidad del producto ha sido realmente satisfactoria, y en cuanto al servicio de envio mas que excelente.

4-0 out of 5 stars Needs more information about keys
The book is pretty good, and offers lots of examples. MySQL is not very simple, and took me a lot of studying to learn. I found that I had to use several books at once to get the hang of things. One thing that this book does not cover very well are table keys (primary, foreign, etc).

4-0 out of 5 stars optimal book
this book is a very completed and updated quick look to database world and optimal reference book for sql/mySQL primer.
Stefano Gallozzi

5-0 out of 5 stars Book on Top from down under
Learning MySQL (Learning)

Get this book!This O'Reilly book "Learning MySQL" first appeared in the book stores at the beginning of the year 2007.The book is written by two PhD authors who seem to have thoroughly tried its contents on their students, at RMIT University in Melbourne, Australia.You can buy this book and then create a splendid software career for yourself, programming Relational Databases.And live happily ever after.

If you are a total SQL beginner, please also buy a more simple-minded introductory SQL text as well; make you favorite pick among the 20-odd SQL texts available in your local bookstore, or read Amazon's reviews associated with all the other SQL books.

Now back to "Learning MySQL".I'm enjoying this book wherever I go, inserting my USB flash drive on any Windows machine I can lay my hands on.I have installed my free copy of MySQL on this low-cost device ($20 for a 4 GigB flash drive), together with Java, Apache Tomcat, FireFox, and other opensource goodies.My point is that this MySQL book covers Windows as well as it deals with Linux and Mac OS X, almost always in the same breath.

I typically try out the book's examples at the mysql> command prompt, but my own final application right now happens to consist of Java servlets, talking to MySQL databases, and running in Tomcat under the Java Virtual Machine (JVM), all on the puny USB flash drive without disturbing the particular Windows machine I'm visiting.

By following the book's examples I have built up a mental toolbox containing all the standard SQL techniques and all the helpful but proprietary MySQL extensions to SQL.Extensions which you might, or might not, want to assimilate, depending on your purity point of view.

As you go through the book's examples on your own mysql> command line, you realize that each example probably in an explanation triggered by questions from the authors' bright MySQL students.It is like sitting in their classroom lapping up the authours' knowledge.And, these authors know their stuff, something that cannot always be said of other SQL books.

One feature, among others in the book, is the authors' short but wonderful Chapter 4, where the reader is led by the hand through The Entity Relationship Model, and through the authors' database examples illustrating the super-important topic of How to map Entities and Relationships to Database Tables.There, the authors also point out existing tools to draw ER diagrams, such as the good free tool "Dia", or MySQL's own free "MySQL Workbench program" which is a very powerful visual database design tool, although still in the beta testing phase.

One last, but not least, comment.It appears that the book is extremely well suited to those Perl or PHP lovers, who want to get their MySQL teeth sharpened.But this reviewer is not into Perl nor PHP, yet, so don't take my word for it. ... Read more

9. Head First PHP & MySQL
by Lynn Beighley, Michael Morrison
Paperback: 816 Pages (2008-12-22)
list price: US$44.99 -- used & new: US$24.00
(price subject to change: see help)
Asin: 0596006306
Average Customer Review: 4.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.

Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.

  • Use PHP to transform static HTML pages into dynamic web sites
  • Create and populate your own MySQL database tables, and work with data stored in files
  • Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY
  • Use cookies and sessions to track visitors' login information and personalize the site for users
  • Protect your data from SQL injection attacks
  • Use regular expressions to validate information on forms
  • Dynamically display text based on session info and create images on the fly
  • Pull syndicated data from other sites using PHP and XML
Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
... Read more

Customer Reviews (38)

3-0 out of 5 stars PHP & MySQL for Amateurs
Unfortunately, I read "Head First HTML with CSS & XHTML" before I read this one.Perhaps I would not have been so disappointed if I'd read this one first.This presentation is more 'Artsy' than 'Technical'.If you're into buying the 'Artsy' type of books then you'll love this one.For me, well, you should throw away the first 200 pages.On page 200 is a nice tidbit I needed to learn, but the book really begins on page 210, where the first 'rules' are presented, and starts to develop in a 'better' fashion from that point.
When I buy a book on PHP & MySQL, I expect, want, NEED to learn how to use PHP to grab data from a web page and use MySQL to put it into a database and vice-versa.I don't care about how to send email using PHP, plus I don't care for the way the authors handle email.There are better ways, existing classes that handle it for you, and they're free.I also don't like books that show you a wrong way to do things - anything, and then have you correct it.It tends to implant 'bad' knowledge into my mind that I don't need.You should start with good, solid building blocks, as they did on page 210 and create a foundation.Then you build up from there.
I assume, after reading the authors' biographies, that they were probably more interested in completing a cute, artsy, publication that skirts through the subjects rather than a more technically proficient work like the authors of "Head First HTML with CSS & XHTML" did.I gave that one 10 stars out of 5!(Yes, I mean that it was twice as good as I could rate it!)It was the first book I've read cover to cover since high school - Class of '65 - other than a couple of Tom Clancy's novels.I should, in fairness, point out that I am a school trained structured ISAM COBOL programmer, now retired, and trying to learn HTML, CSS, PHP & MySQL on my own.I may be a little more critical of the technical material than most, because I expect computer books to present a logical, organized presentation of the necessary material.This one does not.

5-0 out of 5 stars Great For Beginners!
I have been using this book as a work book for learning PHP and MySQL... It is a great book!the format is a little different, but it really works! I would recommend this book to anyone who has a good handle on HTML and CSS and wants to expand their skillset to include server side scripting and database applications.This book is not really geared toward programmers, so I wouldn't recommend it to someone who already knows how to program.

5-0 out of 5 stars Great for Students
I'm a Web Design student, and I got this book for a database class I had to take a little while back. Unfortunately my instructors style of teaching didn't fit my style of learning (in other words I don't learn PHP from a 60 page powerpoint slideshow...). So a friend recommended me this book so that I can just teach it to myself. I gotta say I am very happy with it. For beginners I can't stress this enough how easy this book is and how well it explains everything. I mean the "humor" that the book tries to push is really corny, but once you get past that you can learn some pretty solid principles and easy exorcises that you can apply to a lot of web applications. It mixes PHP and SQL together teaching you the basics of what you need.

Now this book is not a standard textbook that covers every single component of PHP and SQL but more of learning through some basic exorcises. I personally don't like the soulless and dry text book style books that just present everything in the most boring way. This book tries to mix it up and be a little less serious which in my opinion makes it easier to take in. If you are looking to learn basic PHP/SQL applications then I would highly recommend this book. The more advanced programmer may not find it as helpful however.

1-0 out of 5 stars Bad, really bad
While "Head First HTML with CSS and XHTML" is absolutely superb, this one is really, really bad.It attempts to mirror the HTML book's style and format but fails miserably.It's disorganized, liberally sprinkled with typos and errors, follows a haphazard presentation sequence, and its colorless pages have all the panache of a two-week old newspaper left out in the rain. Why would someone print on cheap off-white paper and use light gray type to boot? This book, with its pointless distractions placed randomly on every page, is actually hard on the eyes and even harder on the brain.

My advise is to look for something better. It shouldn't be all that difficult to find.

2-0 out of 5 stars Omits crucial details, poorly written
I bought this book for my wife, a print graphic designer trying to move into web design. She's found it confusing. When she asks me for clarification, it's clear that the authors never really tried out the book on a non-engineer.

1. The first example throws a mailto: link in a web page. My wife wasted an hour configuring her desktop email client (she normally uses gmail) before turning to the next page to see "haha, that's not actually related to anything we want to do".
2. The next example is sending email from a server. This would have been a great example ten years ago, when you could actually get mail out from a random machine without it being discarded as spam.
3. SQL statements are displayed without semi-colons. It's mentioned once, but this book is supposed to be for beginners.
4. The first example of SQL is vulnerable to SQL injection. Fine, it's the first example, but at least say it isn't suitable for production code.
5. Later on, they talk about SQL injection, but the solution they give is to remove unsafe characters, rather than the preferred method of parameterized queries.

These are a handful of specific problems I've seen. I'm sure there are more. In general, it's mostly written to the level of a beginner (which I wanted), but it has too many errors in the details for a beginner to actually follow along.

Also, the examples have the longest names I've ever seen. I don't see what the reader is going to gain by being forced to type "date_this_happened_on" repeatedly. ... Read more

10. PHP & MySQL For Dummies, 4th Edition
by Janet Valade
Paperback: 456 Pages (2009-12-09)
list price: US$29.99 -- used & new: US$9.55
(price subject to change: see help)
Asin: 0470527587
Average Customer Review: 3.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
Here's what Web designers need to know to create dynamic, database-driven Web sites

To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result.

PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited.

  • Explains the easy way to install and set up PHP and MySQL using XAMPP, so it works the same on Linux, Mac, and Windows
  • Shows you how to secure files on a Web host and how to write secure code
  • Packed with useful and understandable code examples for Web site creators who are not professional programmers
  • Fully updated to ensure your code will be compliant based on PHP 5.3 and MySQL 5.1.31
  • Provides clear, accurate code examples

PHP & MySQL For Dummies, 4th Edition provides what you need to know to create sites that get results.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. ... Read more

Customer Reviews (42)

4-0 out of 5 stars Picky Don's review
I am very pleased with the condition of this book, it was better that I expected.When I first ordered it I was expecting a delivery date of 5 to 6 working days out, but was given much longer delivery time of about 3 weeks.If you needed a book sooner, this would not be the way to go.However; that being said, it arrived about a week earlier.Overall I am a happy with my choice to get a used book through this vendor.The condition was like off the book shelf at a store.

4-0 out of 5 stars Excellent tutorial, but not a good reference
This book is an excellent tutorial for someone who already knows how to program and wants to learn PHP and MySQL.It describes many of the callable functions available in the language, but it tells you to go to the PHO web site for a complete list of all the functions and features.The reason I bought a book is so that I can have the book open in front of me and not have to jump back and forth to the web site to look stuff up.

3-0 out of 5 stars Not really for Dummies
I was a dummy -at least about PHP and MySQL. I know HTML fairly well. I'm not a hacker but I am usually a power user on the apps I use. I just didn't know much about PHP and MySQL so I needed a good feel for the overall scheme of how these two fit together and what that meant for site design.

While this book has a good scope, it was just a step or two above the dummy level and that proved an obstacle for me. I found the OReilly Head First book on the same topic a much better introduction. The OReilly books do a lot of basic hand holding so I expected it would take longer but I found that in the same amount of reading and doing time I learned much more about the important skills and concepts and also have a very good understanding of the big picture regarding design.

I now use the Dummies book as a reference, so it is indeed useful, but I thought the Title "...For Dummies" a little misleading if this is your first foray into PHP and MySQL.

5-0 out of 5 stars Damn fine piece of work
If you skim the verbiage, scout the chapter titles, read the section headings and review the code, you will very quickly understand php and the interaction with mysql.

This book will not teach you html.Go read that book.

This book will not teach you sql.Go read that book.

This book gives you a sequential and an object method of programming against a database within HTML.

Each example builds to the following example, until you have the final piece of programming demonstrating the concept.

The index works.

The only addition the author could make is strip the book down into a php and mysql 10 minutes per chapter type of book.

2-0 out of 5 stars Terrible
I would recommend for beginners not to use this book. Even for me (a somewhat intermediate programmer), I had difficulty understanding what was being done and what it did. The example syntax is messy making it hard for readers to understand. There are better approaches for teaching PHP & Mysql. ... Read more

11. MySQL Pocket Reference: SQL Functions and Utilities (Pocket Reference (O'Reilly))
by George Reese
Paperback: 132 Pages (2007-07-17)
list price: US$14.99 -- used & new: US$8.36
(price subject to change: see help)
Asin: 0596514263
Average Customer Review: 5.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

  • How to configure MySQL, such as setting the root password
  • MySQL data types, including numerics, strings, dates, and complex types
  • SQL syntax, commands, data types, operators, and functions
  • Arithmetic, comparison and logical operators
  • Aggregate and general functions
  • Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers
You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.
... Read more

Customer Reviews (9)

5-0 out of 5 stars great knowledge base
For the occasional MySQL programmer this book is a must. I use MySQL to a small degree in my recent game project and this book gives me all the knowledge I need to write simple queries in C++

5-0 out of 5 stars Good no-fluff reference and read
I've always liked O'Reilly books, and this is no different.It's a small no-fluff reference that makes for a good read as well.The book is physically small enough to fit unobtrusively in your laptop bag without causing too much of a bulge.

Since it is written as a pocket reference, it of course doesn't have all the commands or even all the variants/options for commands.What is does have are the commands and syntax that you are likely to use the most with some good examples.

Just know what you are and are NOT getting.It's not a bible, a step-by-step, or a cookbook.It is (as it is labeled) a pocket reference, at which it excels.Highly recommended.

5-0 out of 5 stars Explanations are accompanied by tables and examples for maximum efficiency.
George Reese's MY SQL POCKET REFERENCE 2ND EDITION covers Version 5.1 and provides SQL statements, functions, and insights into its variations and utilities. Explanations are accompanied by tables and examples for maximum efficiency.

5-0 out of 5 stars Excellent Quick Reference for MySQL RDBMS
Reese hits a solid triple to start the inning off and scores easily on the wild pitch thrown by the reader who says that the GRANT section is wrong. This book works easily and appropriately at your deskside.I found the book to be a very simple, easy-to-navigate reference text that presents the most important aspects of MySQL in the quickest, most logical manner. It is very easy to thumb through with every possible random page landing at a topic of interest.In a way, it was like working with a familiar dictionary, you know the kind, where you just kind of naturally crack it open near the word you're accessing and flip a couple of pages either direction to arrive at the exact reference location. In that vein, I'd perhaps recommend that the margins contain "bread crumbs" telling us where we are in the book, but it isn't necessary since thicker sections often obviate themselves with just another page turn.Each page does have the chapter title in the margin, so my point is really one of nit-pickieness rather than a true critique. To its credit, the layout of the book presents the content in a manner that follows the O'Reilly "risen bar" standard.It is easy to scan through the entire reference flipping pages as quickly as possible so that you are able to arrive at your sought information within as much as a second or two.The bold text draws your eye to the page and the size of the page allows one to capture everything in a single glance. In my usage of the book, I found it very accurate and useful.I am a regular MySQL user and the formatting is very familiar to me.I highly recommend this book.If you are already familiar with SQL and the basics of database schema design, this is the perfect reference.I found it amazingly faster than loading the MySQL PDF manual and searching through potentially dozens of hits for the keywords sought.Even at the full cover price, this book is a value-added service at my side. The sections on operators, functions, stored procedures and triggers make this book an invaluable tool for the DBA or programmer who knows the material, but fails to remember every single aspect about the syntax AND who is tired of seeing that familiar: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near..." The text also finds welcomed complement from the numerous examples of using commands and SQL keywords.They are invaluable for immediately deciphering the sometimes too-numerous options of a command. I don't know that the book has taught me anything new at this point, but it certainly makes finding the details of what I already know much easier.Because of its brevity and its ease-of-use, it has made me want to play around with some of the various features of MySQL that I do not regularly use.That alone is going to teach me something new sooner or later! If your budget is constrained to a single reference item on MySQL, you can't go wrong with this very portable pocket reference. The back cover says: "When you reach a sticking point, but have to get to a solution quickly, MySQL Pocket Reference is the book you need." I agree completely.

5-0 out of 5 stars Entry level pocket reference
MySQL has gained a lot of functionality after this book was done, but if you are a infrequent developer and like to have a quick reference into basic MySQL functions this book is great.

... Read more

12. MySQL Crash Course
by Ben Forta
Paperback: 336 Pages (2005-12-22)
list price: US$29.99 -- used & new: US$12.72
(price subject to change: see help)
Asin: 0672327120
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, full text search, and much more
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and Cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

... Read more

Customer Reviews (30)

5-0 out of 5 stars Such an excellent MySQL book
Okay, for the naysayers, this book is imperfect!

Good, got that out of the way.

I'm in awe of how well Forta has arranged the subject matter, addressing things I needed to know, mentioning things I wanted to learn more about, and generally providing examples of what was most relevant to the current discussion.

This is not a Crash Course.This is a textbook, pure and simple, and it earns the distinction.

5-0 out of 5 stars Suitable Reference
I approve of this book as MySQL by Ben Forta is a great reference as well as hands on instruction.
I had the opportunity to hear Ben Forta speak at the University of StThomas about the new COld Fusion 9 which had not yet been released.

5-0 out of 5 stars Great for Begginers. A great reference for the rest.
I am not a programmer and when I bought this book I only had experience with Microsoft Access (without knowing VBA). This book was the best way to learn MySQL for someone like me. It is practical, clear and complete enough for acquiring a solid medium-level skills in MySQL.

Now that I have those skills, Ben Forta's little book still serves me as a great reference book. So if you want to learn MySQL and have no programming experience don't look further THIS IS THE BOOK FOR YOU!

3-0 out of 5 stars OK for what it is
It's important to understand exactly what this book is and is not. It IS a broad introduction to the SQL dialect as available in MySQL. It performs its job satisfactorily.
However, you are almost completely on your own when it comes to anything to do with setting up, configuring and problem-solving. For example, when it comes to setting up the example tables, the instructions are extremely sketchy: unless you know that, under Windows, you have to escape '\' as '\\', you will run into problems running the SQL scripts. Similarly, how to start and login to MySQL from the command line using any other account than root is not discussed. These are basic details where any true novice is going to need some handholding. Confusingly, the author refers to 'datasource' which, it seems (it's not explained) is a synonym for 'database'. Thanks to these sorts of lacunae, it was difficult to 'hit the ground running' (author's claim) and you may have to do some googling around before you can get down to business.

5-0 out of 5 stars Great Intro to MySQL
This book does a superb job of introducing MySQL, and RDBMSs in general.Ben Forta strikes a good balance between detail and simplicity in a short, easy to read guide.Very well done! ... Read more

13. Beginning PHP and MySQL: From Novice to Professional, Fourth Edition
by W. Jason Gilmore
Paperback: 824 Pages (2010-09-24)
list price: US$49.99 -- used & new: US$31.49
(price subject to change: see help)
Asin: 1430231149
Average Customer Review: 4.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore’s authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more.

You’ll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you’ll also learn how to effectively integrate them in order to build robust data-driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

What you’ll learn

  • How to install and configure Apache, PHP 5.3, and MySQL
  • PHP and object-oriented programming basics
  • New PHP 5.3 features and how to use them
  • How to move beyond basic PHP, including using the Zend Framework
  • How to use MySQL to securely store your website's data
  • How to use MySQL Workbench to manage your database

Who this book is for

Developers who want to harness PHP and MySQL to create powerful web applications

Table of Contents

  1. Introducing PHP
  2. Configuring Your Environment
  3. PHP Basics
  4. Functions
  5. Arrays
  6. Object-Oriented PHP
  7. Advanced OOP Features
  8. Error and Exception Handling
  9. Strings and Regular Expressions
  10. Working with the File and Operating System
  11. PEAR
  12. Date and Time
  13. Forms
  14. Authenticating Your Users
  15. Handling File Uploads
  16. Networking
  17. PHP and LDAP
  18. Session Handlers
  19. Templating with Smarty
  20. Web Services
  21. Secure PHP Programming
  22. SQLite
  23. Building Web Sites for the World
  24. MVC and the Zend Framework
  25. Introducing MySQL
  26. Installing and Configuring MySQL
  27. The Many MySQL Clients
  28. MySQL Storage Engines and Datatypes
  29. Securing MySQL
  30. Using PHP with MySQL
  31. Introducing PDO
  32. Stored Routines
  33. MySQL Triggers
  34. MySQL Views
  35. Practical Database Queries
  36. Indexes and Searching
  37. Transactions
  38. Importing and Exporting Data
... Read more

Customer Reviews (110)

4-0 out of 5 stars A useful reference and study text for progrmmers new to PHP
This book is almost overwhelmingly thorough, which made it, in my experience, an extremely useful resource in preparing for the Zend PHP certification exam, as well as for learning and daily use. While it's incomplete where the test is concerned-you won't find a listing for "Reflection" in the index, for example-it's a useful reference for most of the material on the exam.All of the built-in string and array functions are described clearly and concisely, with examples of use. PHP installation and configuration settings are laid out in the kind of painful detail expected by the exam. There's an introduction to object-oriented programming,overview of regular expressions and a whole series of chapters detailing some of the most useful features of PHP and reviewing some of the most common problems (web services, user authentication, and secure programming, to name a few). And that's before we reach the second half of the book, providing the same kind of detail for MySQL, including PHPs several interfaces to it.

One limitation, from the perspective of an absolute beginner, is the lack of large-scale examples. Gilmore doesn't walk you through the development of a web application; the book is more of a reference text, using smaller examples to illustrate small, specific topics, with the expectation that the reader can assemble those ideas into usable examples. This was probably necessary to enable the chapters to function as individual units, which is one of the book's major strengths.

Books of this size can be daunting to a reader. Gilmore's friendly, readable prose goes a long way toward making this one approachable, as does the modularity, allowing a reader to digest only the chapters needed at any given moment.

5-0 out of 5 stars Excellent book
This is an excellent book for learning how PHP works and how you can use it.I used it for assistance with creating my first PHP script.All of the information was very clear and straight-forward, as well as being easy to follow.I highly recommend that anyone that is interested in using PHP and building PHP driven web sites purchase and read this book, because it will be very useful.This is a very well written book and is an excellent resource.

5-0 out of 5 stars Where to go when you want to know
I needed to learn PHP and MySQL quickly. It is hard to know which book and which author. So why did I pick this book? And why do I recommend it?

The structure outlined in the book's table of contents, a quick look at Jason's website (chock full of useful information) and the fact that this is an Apress book quickly cemented my confidence. I received the book earlier than expected.

I literally devoured the 1st 18 chapters in an afternoon following the installation of a MAMP environment. I believe that this is a testimony to the clarity of the writing, the structure, and the examples. I typed most of my own and only downloaded the source code from Jason's site later. I highly recommend registering on the [...] site.

I had registered for a PHP and MySQL course prior to purchasing the book but didn't start it until after chapter 20. This book helped me accelerate my website development and made the class super easy. I probably could have saved the course cost and just used the book.

I strongly recommend this book. Thus far I have found a consistent level of quality authors at Apress.

PS - I had no HTML or web development skills before picking up this book. I did have classical 'C' and PERL experience

5-0 out of 5 stars Highly Recommended
This was one of the first PHP/MySQL books I purchased.Since then I have purchased 4 or 5 others and I have to say this is one of the best.I used this book along with the PHP Architect Zend study guide to pass the Zend PHP5 Engineer test.I've noticed a lot of technology books suffer from too little editing but I don't recall seeing any errors in this one...

4-0 out of 5 stars Great for beginners
I was looking for book to learn PHP and I came to amazon for this.This wasn't the first book that came up but it was the one that looked like it would be easiest to learn from.This book worked great for teaching myself PHP and I would highly recommend buying it. ... Read more

14. MySQL Administrator's Bible (Bible (Wiley))
by Sheeri K. Cabral, Keith Murphy
Paperback: 888 Pages (2009-05-11)
list price: US$49.99 -- used & new: US$26.61
(price subject to change: see help)
Asin: 0470416912
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more. ... Read more

Customer Reviews (8)

5-0 out of 5 stars An excellent resource for MySQL DBA's
I have several books on MySQL on my desk at work, but I have learned to go to this one first when I need an answer to a specific problem. It covers everything from from syntax to concepts. It is thorough and gives enough information to get the job done, but not so much as to be overwhelming. I think this is one of the better technical books I have encountered in many years, and highly recommend it to anyone who needs to actually get into the inner working of a MySQL database.

5-0 out of 5 stars The best Mysql DBA book on the market
I have work as a DBA since 1993 and with Mysql for the last 9 years, and I have to say of all the DBA books that I have read, this is the best on the market at this time. The book is well written, Sheeri Cabal has hands-on experience working with Mysql, and it shows. Sherri is also no stranger to the Mysql community. My hat off to the authors for a job well done. In regard to the lone negative review of this book, if you have good experience working on other RDBMS but is new to Mysql, you should be able to make use of this book, if you have no experience with RDBMS, this is not the right book for you.

5-0 out of 5 stars MySQL Administrator's Bible - Review
On the front cover of MySQL Administrator's Bible is a sentence that reads:

"The book you need to succeed!"

I must say, I do agree. Authored by two very experienced DBAs, Sheeri Cabral and Keith Murphy, they've combined their talents to cover what you really need to know to succeed. This book is very versatile. If you're new to MySQL, or experienced in another database and have to start administrating MySQL, you need this book. I can honestly say, even if you have years of MySQL experience, you will learn something new. I did. Divided into four parts, MySQL Administrator's Bible covers your First Steps with MySQL, Developing with MySQL, Core MySQL Administration and Extending Your Skills.

First Steps with MySQL starts with a gentle introduction to MySQL with company information, which seems to be changing annually, and most importantly, the MySQL community itself. What makes MySQL so fantastic is the community. After that, you'll be lead into installing and configuring MySQL on various platforms including Linux, Windows and Solaris while touching on post installation configuration too. Basic security is covered as well as some tips on troubleshooting and accessing your new MySQL installation using tools included with MySQL or using third party software.

Developing with MySQL covers the MySQL Language Structure and if you're coming from another RDBMS, it covers how MySQL deviates from the SQL standard by extending that standard to make MySQL the number one open source database used on the Internet. After that, this section covers the same type of topics covering just about any other mainstream databases such as using stored procedures, cursors, events, views and transactions.

The Core MySQL Administration is the heart of this book. It covers MySQL server tuning, covering all major storage engines including MyISAM, InnoDB, Falcon, PBXT, and NDB engines including the first time I've seen in print, the Maria storage engine. An entire chapter is devoted to implementing cache tables and using the query cache. Memcached is also mentioned, and mentioned again in the final section. Continuing on with what I consider the most important job of a DBA, backup and recovery. Databases are very central to running a business, any data loss could put a company out of business. Be prepared.

This section gives a solid introduction to the topic of dealing with users, and how they are managed within MySQL. Count on covering GRANT/REVOKE, using SHOW GRANTS and mk-show-grants MaatKit tool. Partitioning, logging and replication and measuring performance rounds out this section.

If you have experience with another RDBMS, plan on spending a significant amount of time in this section. Not that the other sections aren't important, they are, but this is the bread and butter of what a MySQL DBA does on a daily basis.

Extending You Skills section can be considered getting your Masters in Database Administration. Just about every DBA will have to tackle improving queries and the tuning of indexes. The second most important job of a DBA is monitoring performance of your MySQL server. Don't let your users be your first line of monitoring! Be proactive, there are plenty of open source monitoring tools available. The most popular are discussed, as well as MySQL Enterprise and third party companies too. MySQL Data Dictionary is covered in in detail over 58 pages. This is the most I've read in any book about the data dictionary.

Last but not least, most high performance MySQL systems involve scaling up or out. It covers the usual suspects of replication, MySQL Cluster, and memcached. MySQL Proxy is initially covered and has an appendix to expand on that information. MySQL Proxy itself is worthy of its own book. (hint, hint :) ) Two more appendices cover MySQL Functions and Operators, and additional resources.

Even though this book targets MySQL 5.1/6.0, there is plenty of information that will apply to 5.0. If you're still on 5.0, don't hesitate to pick up a copy. This will be a book that can stay with you as your upgrade to 5.1 and beyond. The companion website - [...]contains all the code from the book too, rounding out this fine tome.

What didn't I like about the book? There are only a couple of things, all personal I'm sure. First, I really don't care too much for tables of options from the various tools. Most open source tools are developed rather quickly and options change. This could render portions of the book out of date quickly.

The other thing I noticed that wasn't mentioned in the book was the community versions of MySQL supported by Open Query and Percona. The latter has their own storage engine, XtraDB and backup solution, XtraBackup.

All in all, this is a very solid book on administering MySQL. This book digs deeper, the experience of the authors really show. Well done Sheeri and Keith!

Disclaimer: The publisher provided me with a copy of MySQL Administrator's Bible.

5-0 out of 5 stars A good balance of reference and how-to
This is a comprehensive reference guide to MySQL that's accessible to beginning DBAs or DBAs familiar with another database. It has enough detail to be a useful companion throughout a DBA's career. It also covers many related technologies, such as memcached, at a moderate-but-useful level of detail. This isn't exactly a how-to book, and it isn't exactly a reference manual; it's more of a blend of the two.

The audience will depend on personal preferences. Some of the reference material is the type of thing I would look up with command-line --help options or the MySQL manual. But there are times when the reference aspect of the book is uniquely valuable. For example, the online documentation tends to list things alphabetically; the book might break them down into groups by function. An example is the sql_mode parameters, which it groups into categories like "Getting rid of silent failures, silent conversions, and silently allowing invalid data."

The book is divided into four parts: first steps, developing with MySQL, core administration, and a set of chapters and appendixes grouped under extending your skills. I think this organization works well.

Coverage is for MySQL 5.1 and 6.0. As far as I know, this book contains the most complete coverage of MySQL 5.1 in print.

By the way, I'm the lead author of High Performance MySQL: Optimization, Backups, Replication, and More and I think the two books are very complementary.If you're new to MySQL, then start with this book, and later you might consider reading mine as well.

5-0 out of 5 stars The best guide I've found to setting up and administering MySQL databases
Some background first: I've used MySQL for two decently-sized programming projects in the past, on the developer side. More recently I was hired to design, build and administer the back-end of a web application. MySQL seemed the natural choice. With background only in the developer's role, I had a huge amount to learn.

I started out by buying the MySQL Administrator's Guide and Reference:

and a more general book on Database Administration:

The former was pretty terrible, and it's all available online anyways so there's absolutely no reason to buy it. Why is it so bad? Despite being written by MySQL, it is completely impractical and totally bogged down with details. I defy you to figure out how to efficiently back up your database by using that guide. I couldn't.

The latter was very useful for introducing concepts like data normalization and, while a little out of date, gives a quick sense of the products that are out there. I highly recommend it as a first read. but it's not MySQL specific - so where to go then?

Finally, I found this book. It took me about 1 minute to find the tools I would need to back up a database and another 10 seconds to find a detailed discussion of what's going on when you back up a database.

It's also very recent (as of 2009/06) - it really reflects the state of the tools out there and I was pleasantly surprised to find that all of the developments I had been reading about in my online research were reflected in the book. Instead of glossing over complex topics like MySQL Cluster, memcached, DRBD, Linux HA (see, I wasn't kidding about its coverage), it points you to external resources that are actually helpful.

I haven't yet read all of it but, to my knowledge, there is nothing comparable out there. If you have a good idea of the basics behind database administration and need a practical guide to how to actually administer a MySQL database, including the tools available to you, I'd seriously recommend that you take a look at this book.

- I was a bit concerned about the book's information on early-stage tools like MySQL Proxy and MySQL 6.0. They haven't been released for general use and are not certified as stable, but the book just lists them with other tools as if you could just drop them in. Be careful.
- As another reader pointed out, it's not the easiest read. But then, if you've never used SQL, never mind MySQL before, then trying to understand concepts like the difference between READ COMMITTED and SERIALIZABLE isolation levels will surely result in pain and death. This book is much better if you have a question like "How do I backup a MySQL database?", "How do I make a trigger", or "How do I set up replication?" ... Read more

15. MySQL Cookbook
by Paul DuBois
Paperback: 976 Pages (2007-01-27)
list price: US$49.99 -- used & new: US$31.49
(price subject to change: see help)
Asin: 059652708X
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to:

  • Access data from multiple tables at the same time
  • Use SQL to select, sort, and summarize rows
  • Find matches or mismatches between rows in two tables
  • Determine intervals between dates or times, including age calculations
  • Store images into MySQL and retrieve them for display in web pages
  • Get LOAD DATA to read your data files properly or find which values in the file are invalid
  • Use strict mode to prevent entry of bad data into your database
  • Copy a table or a database to another server
  • Generate sequence numbers to use as unique row identifiers
  • Create database events that execute according to a schedule
  • And a lot more

MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.

Amazon.com Review
Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, andteaches his readers a lot about MySQL and its attendant APIs in the process.

DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall

Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques. ... Read more

Customer Reviews (28)

5-0 out of 5 stars My son the computer tech was right--once again.
I need to learn about MySQL for my small business. My son the computer tech said this was the book I needed to get me up to speed quickly. He was right. It's concise, apparently complete, and easy to understand, even if the subject is a bit mind-bending at times. Without a book like this, I wouldn't enjoy the learning experience; it would be less pleasant than another knee surgery.

This book is highly recommended by a guy who has read a lot of instructional material in a 40-year career that included service as a part-time college instructor...and by his adult son whose computer library cost his dad thousands of dollars.

4-0 out of 5 stars Quickstart to MySQL Development

I really enjoy cookbooks because of their no nonsense organization.This MySQL book exactly fits that description.Chances are just scanning the table of contents you'll find the question you are asking with the answer and explanation at your fingertips.

Nuggets of information I found quickly include: paging producing HTML output with the mysql client, checking and changing a tables storage engine, working with fulltext searches, summary and grouping query examples, importing data from CSV, exporting in various formats, dealing with auto_increment columns, sequences, deletes, gaps, and so on.Also handling duplicates, detecting, eliminating, working with transactions, and a whole lot more.

The book is mainly geared towards web applications and MySQL.The languages that they cover include Perl, Ruby, PHP, Java, Python.If you're using any of those languages for your web application, it is more than likely you want a copy of this book.It's very quick and painless to lookup how to do something, and not have to wade through tons of information that's not relevant to you.

The target audience for this book is really developers not DBAs, so keep that in mind.If you're doing web development in Ruby, PHP, Perl, Python or Java, you should consider this book.It concentrates solely on the how to do specific things, so you won't get weighed down by too much theory and so on.With that in mind, it's not per se a book on performance, testing, benchmarking and profiling applications in those languages, so if that is what you need, you'll require additional material.

5-0 out of 5 stars Teasure Trove of MySQL Recipes
At 900+ pages this book addresses a lot of common SQL tasks. And that's what a good cookbook should do. Not only does it present the SQL queries in the MySQL dialect, it also covers how to pump those queries through Pearl, Ruby, PHP, Python, and Java APIs.
As an added bonus you can actually use this book to learn SQL. I thought the chapter on JOINS was especially well written.

5-0 out of 5 stars excellent resource
This book is
-a great resource for those looking to implement various mysql functions
-a great resource for database programmers
-a trove of information on powerful query and sort techniques

Finding information about the topic you're looking for is a breeze in this book - the chapters are well-organized, and this book has anwered all questions I've posed to it....

The cookbook is a powerful tool to those who know some mysql, and some dB design. I recommend that you use another book to learn basic mysql (or just an online tutorial), and another to learn database design (Navathe).

4-0 out of 5 stars True to the Title
As indicated, this book is true to its title.It is a cookbook, by which I mean it contains a great number of (generally useful) recipes of varying complexity, but lacks detail and analysis that a more focused text would have.

Mr. DuBois and O'Reilly publishing are clearly targeting a wide audience: the recipes range from frighteningly simple (e.g. 3.1, Specifying Which Columns to Select) to fairly sophisticated (e.g. 12.14, Performing a Join Between Tables in Different Databases).The recipes are typically clearly written, with ample supporting code examples and few typographical errors.

I must also note that Mr. DuBois nicely avoids a pitfall many authors (the competence of whom I have to question) in this genre encounter: failure to weave security considerations into the text.While other books often mention security as an afterthought, or worse include code examples featuring disasters like non-escaped strings (hello, SQL injection!), DuBois explicitly points out the need to sanitize input and writes code examples that demonstrate the use of prepared statements in best-practices.

Unfortunately, in other areas he is less thorough.For example, only passing mention is made of the (possible) dependence of FULLTEXT indexes on choice of storage engine.There is an entire chapter on handling duplicate rows, but the oft-needed (and non-obvious) process for removing pseudo-duplicate rows differing only by a primary key field is not directly addressed.Stored procedures, triggers, and other new additions to MySQL are among the least-well understood but most powerful features of the database engine, yet astonishingly little space is spent on them.(I could understand not discussing them in depth as there are other books available, but length did not seem to be a concern anywhere else in this book.)

In summary, the book is an excellent resource for novices and experts alike - but only as a starting point.To return to the cooking analogy, the book at times feels like it is loaded down with recipes on how to add sugar to flour, but omits recipes on how to ice the cake. ... Read more

16. MYSQL in a Nutshell (In a Nutshell (O'Reilly))
by Russell Dyer
Paperback: 576 Pages (2008-04-15)
list price: US$34.99 -- used & new: US$19.99
(price subject to change: see help)
Asin: 0596514336
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.

The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.

Inside, you'll find:

  • A thorough reference to MySQL statements, functions, and administrative utilities
  • Several tutorial chapters to help newcomers get started
  • Programming language APIs for PHP, Perl, and C
  • Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory
  • New chapters on replication, triggers, and stored procedures
  • Plenty of new examples of how MySQL is used in practice
  • Useful tips to help you get through the most difficult subjects
Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.

... Read more

Customer Reviews (6)

5-0 out of 5 stars Great Reference
I don't think a long, comprehensive review is needed here. This is a quick reference guide to have handy when you're working on a project or whatever. You won't learn MySQL from it but as long as you are already familiar with it, it serves as a great, quick reference, especially when you are utilizing keywords or routines that you don't normally use and therefore don't have in the forefront of your mind. If you need a bit of a field refresher, this works great!

5-0 out of 5 stars Compact And Clear MYSQL Reference
'MySQL in a Nutshell' is another solid release in the family of 'Nutshell' books by O'Reilly.As with all other Nutshell books, this isn't a learning book, moreso a shorter reference manual for experienced developers who know what they are using and need a guide to help them out through the process.With MySQL In A Nutshell you are getting exactly that.Spread over nearly 550 pages and 19 Chapters, here's an overview of the content within:

01. Introduction
02. Installing MySQL
03. MySQL Basics
04. Security, User Statements, Functions
05. Database And Table Schema Statements
06. Data Manipulation Statements And Functions
07. Table And Server Administration Statements And Functions
08. Replication Statements And Functions
09. Stored Routines Statements
10. Aggregate Clauses, Functions And Subqueries
11. String Functions
12. Date And Time Functions
13. Mathematical Functions
14. Flow Control Functions
15. MySQL Server And Client
16. Command-Line Utilities
17. C API
18. Perl API

The layout is good, separation of data is intelligently laid out and the writing is solid.If you are a MySQL developer or admin that is looking for a resource by your side at all times this is a great book to have!!


4-0 out of 5 stars It does not cover MySQL 5 or later.
It's a great reference but dated. If I had known that it only covers through version 4, I would not have purchased it.

5-0 out of 5 stars MySQL and how to use it effectively!
The book is "A Desktop Quick Reference" just as billed on the cover.It is explicitly MySQL-centric and doesn't stray from that core message.It is extremely up-to-date considering the rapidity of movement in MySQL development progress.

I feel that its author, Russell Dyer is the kind of person who is easy to talk to and immediately be comfortable with based on his style and presentation in this book.

The content of this book is very well organized in keeping with the finest traditions at O'Reilly & Associates.There is an installation guide, tutorial, SQL syntax reference, MySQL built-in functions section(s), command-line utilities reference and programming languages API references for PERL, PHP and C.These API references demonstrate commonplace MySQL usage through clear, easy-to-read examples that make good sense.

It is a very comprehensive text that reads as easily as a favorite novel yet is concise enough to be your first "go-to" on MySQL issues you may face day-in and day-out.It is truly the "most advanced kingfisher" (cover animal) on the topic and, like the Pied kingfisher, it is lightweight and demonstrates keenly honed survival skills.

I use MySQL daily and I find it very useful and enjoyable.I don't want to become an SQL guru or even a DBA, as a programmer, I enjoy having MySQL In A Nutshell close at hand so that I can focus on writing code.Thank you Mr. Dyer (and the folks at O'Reilly) for a job well-done!I heartily recommend it to everyone using MySQL.The convenience of this publication clearly outweighs its cost.Newcomers and RDBMS "old-timers" will appreciate this book equally.

4-0 out of 5 stars Another Solid Nutshell Book
Ah, "Nutshell" books - you gotta love `em. Or maybe you don't. I won't get into the pros and cons of online documentation versus books because this subject has been rehashed ad infinitum. Truth is, there are pros and cons for both, and we each have our own reasons for our own preferences.
That being said, if you like book documentation - and "Nutshell" books in particular - then you will like this book. I happen to think it is a good idea to tear yourself away from the keyboard/screen every once in awhile, and the "Nutshell" books give you a good reason for doing so.
I'm not a SQL expert, so I liked the tutorial-flavored introductions at the beginning of each chapter, followed by the conversational tone of the clear and concise examples. I did not have this book when I first started programming using MySQL, and that's too bad because it could have saved me a lot of wasted time with its explanations of some of the more nefarious "gotchas" of the language.
I have but one criticism and one suggestion:
Criticism: The following APIs are covered at the end of the book: Perl, PHP, and C. I can see leaving out COBOL and Lisp (if there are even APIs for these languages), but Java? Granted, the Java interface to MySQL is well-documented in many places, but if you are discussing the *major* programming language APIs to MySQL then you should do just that.
Suggestion: The beginning of the book provides an introduction to MySQL via command-line instructions. I can see doing this, even though no one interacts with databases through the command line. What I think would be even more useful would be a brief discussion of the two tools that everyone does use: MySQL Administrator and MySQL Query Browser. A couple of chapters (along with some screen shots) of what they are, why we need them, where to get them, and how to use them would really make this book perfect. (If you don't forget that Java API chapter!) ... Read more

17. MySQL Stored Procedure Programming
by Guy Harrison, Steven Feuerstein
Paperback: 640 Pages (2006-03-28)
list price: US$44.99 -- used & new: US$23.99
(price subject to change: see help)
Asin: 0596100892
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL's new procedural language has a straightforward syntax, making it easy to write simple programs. But it's not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:
  • MySQL stored programming fundamentals -- tutorial, basic statements, SQL in stored programs, and error handling
  • Building MySQL stored programs -- transaction handling, built-in functions, stored functions, and triggers
  • MySQL stored programs in applications -- using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
  • Optimizing MySQL stored programs -- security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices

A companion web site contains many thousands of lines of code, that you can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

... Read more

Customer Reviews (12)

5-0 out of 5 stars Excellent Book
Great book, excellent explanation, covering the very advanced usage and power of Stored Procedures capability in order to bring greater efficiency of application.
Very clear style of writing, good examples with a detail explanation.
Definitely recommended book.

5-0 out of 5 stars Much more than expected
This book clearly covers stored procedure programming well.Of course, it goes over basic syntax and provides examples, but it also goes much farther than that.This book discusses optimization of MySQL queries regardless of the use - in or out of sprocs.It also did a very nice job of discussing the use of cursors - the ability to iterate through the results of a query without being pelted with the entire result set all at once.

If you're developing on MySQL 5 or greater, and you're serious about letting the database handle things that make sense (i.e. denormalization, administration, and putting business logic into the database), this is an excellent resource.


o Thorough coverage of
- o stored procedures
- o functions
- o triggers
- o cursors
o Explains stored procedure optimization very well
o Serves as stored procedure cookbook
o Excellent coverage of stored procedure best practices
o Demonstrates use of stored procedures with languages like PHP, Perl, Java, and others.


o Title doesn't do it justice.

5-0 out of 5 stars the first and only Mysql stored procedure book
This is the first and only book about Mysql stored procedured and since it was written by the query tuning guru Guy Harrison, it also includes nice tips on query tuning. Highly recommended, just be forewarn that this is for advance Mysql developers or DBA only. Also, be aware that Mysql stored procedure as of release 5.0 and 5.1 won't buy you much performancesince Mysql parse stored procedures scripts every time it run unlike other RDBMS like Oracle and MSSQL. If you want better performance,you should make use of prepared statements inside a stored procedure.

5-0 out of 5 stars MySQL Stored Procedures, In Depth
I have been working with MySQL for several years as a database back-end for Java, Ruby and C# programming projects. After upgrading to version 5, I have been meaning to look into MySQL's support for stored procedures.

The MySQL Stored Procedure Programming book was my first read on the subject and I found it quite useful. It covers not only stored procedures, but also functions and triggers, collectively called 'stored programs' in the book. While there are many books on MySQL, this book is dedicated to the stored programs domain and provides a lengthy treatment of the subject.

During the introduction, the authors provide a veritable laundry list of MySQL resources including many books and websites. The basic tools for creating stored programs in MySQL are visited and help set the groundwork for a 'read, type in the example and run it' feedback loop. Throughout the book, the examples are clear and easy to follow.

The introduction is followed by a brief tutorial, highlighting stored procedures, functions and triggers. What follows is two sections of chapters, over 200 pages in length, diving into the details of the stored procedure language fundamentals, blocks, conditional statements, iterative programming, error handling, the creation and maintenance of stored programs, transaction management, MySQL built-in functions, stored functions and triggers.

The next section of the book is of particular value to software developers that use MySQL in their applications. Over 150 pages showing you how to use MySQL stored programs from PHP, Java, Perl, Python and .NET. The Java section even shows the basics of using stored procedures with Hibernate and Spring.

After that, you'll be greeted with a 110 page medley of options to help you optimize your MySQL stored programs. The subject of tuning your SQL is addressed over the course of three chapters, from basic through advanced tuning topics. Additional optimization techniques such as reducing network traffic with stored programs, optimizing loops, recursion, cursors, trigger overhead and more are found in the final chapter of this section.

The book closes out with a chapter on best practices in MySQL stored program development. MySQL Stored Procedure Programming has earned a space on the MySQL shelf of my technical library. It's a fine book that will help you take your MySQL programming experience to another level.

3-0 out of 5 stars MySQL Stored Procedure Programming
The good:I found to book to be generally useful. The approach the book takes is good. Lots of examples are provided along with a good amount of explanation.

The not-so-good:There seem to be quality or editorial issues with some of the examples. When I run them through the query browser in MySQL version 5 I have problems with some of them. For example Example 2-7 calls another procedure new_salary, which doesn't seem to exist by that name in the book or on the website. This makes it much more time consuming for a newbie to actually run and digest the examples than it should. ... Read more

18. PHP & MySQL Web Development All-in-One Desk Reference For Dummies
by Janet Valade, Bill Ballad
Paperback: 672 Pages (2008-01-29)
list price: US$34.99 -- used & new: US$9.98
(price subject to change: see help)
Asin: 0470167777
Average Customer Review: 3.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination!

PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business.

It’s easy to find what you need in this handy guide. You’ll discover how to:

  • Find and acquire all the tools you need and set up your development environment
  • Build PHP scripts to make your Web site work
  • Create a MySQL database that visitors can access
  • Summarize and sort data results
  • Design and implement user access control
  • Build a shopping cart application
  • Create extensions that make your site more useful

With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it! ... Read more

Customer Reviews (8)

4-0 out of 5 stars Very helpful
I got this book for a class in PHP and MySQL, and it has proven extremely helpful.It is very clear and easy to understand.I highly recommend it for beginners in PHP.

5-0 out of 5 stars This book explains it a from the absolute bottom so even a door would understand it - I like that
I am new to PHP programming and I like the way the book explains the good stuff and the bad stuff and even shows examples of both typs and explains what really happens.

2-0 out of 5 stars Poorly Proof-Read
I had a lot of expectations from this book as it was a branded 'For Dummies' book, but alas from the beginning of Chapter 2 onwards, typos and mistakes start appearing thick and fast; And we're not talking about mistakes in English here either, we're talking actual mistakes in the printed code, and in the associated explanations of the printed code, which frankly, if you are a beginner and not able to discern that it's a mistake, is a fundamentally suicidal mistake for a reference book to make.Luckily, I'm quite smart (yay!), and so I was able to terminate my reading experience after only 130 pages and get something else.Avoid this book, as it will only tarnish your learning experience.Quite sad really.

1-0 out of 5 stars Thick Book Thin On Content
A collection of small writings slammed together to create a rather thick tome and none of the sections go into sufficient depth to really teach much.

2-0 out of 5 stars Mistake heaven
I'm sorry, but after going through just the first couple chapters in Book II, I've already encountered many mistakes in the reading. I enjoyed the Java book I read by this publisher, but this one clearly wasn't proofread or something because there is misleading text, and coding that might confuse anyone brand new to programming.

Luckily, I only checked this out from my school library because I would have been quite disappointed if I spent money on this book to only find it with many mistakes in the first couple days of my reading.

Others might want to explore more options when trying to learn php because when I start concentrating more on where the errors are in the book, then I get side-tracked into actually learning the language because I'm all hung up on these errors. ... Read more

19. Understanding MySQL Internals
by Sasha Pachev
Paperback: 256 Pages (2007-04-10)
list price: US$49.99 -- used & new: US$26.13
(price subject to change: see help)
Asin: 0596009577
Average Customer Review: 5.0 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description

Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:

  • Core server classes, structures, and API
  • The communication protocol between the client and the server
  • Configuration variables, the controls of the server; includes a tutorial on how to add your own
  • Thread-based request handling -- understanding threads and how they are used in MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL's performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication

Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.

... Read more

Customer Reviews (6)

5-0 out of 5 stars Great service
The book was for a son.It arrived very quickly and in perfect condition.

5-0 out of 5 stars Provides excellent content for those working on MySQL
I have been working on a project to make some changes to MySQL server
operation.Learned a lot through code review & trial and error!Recently
purchased this book and it is excellent!Wish we had it months ago.

The author knows what he's talking about. Provides a great overview of the
architecture, file and subsystem layout.Also provides great information on using the 'built in' debug capability of the server -- very useful!

I was expecting to be disappointed, I was not.The content was right
on the mark for those folks interested on working on server internals.

5-0 out of 5 stars Lift the magic veil
An excellent overview of the MySQL codebase, philosophy, and the design decisions that have made MySQL what it is today. Even though I have never touched the MySQL source before (it can be a daunting beast for the uninitiated), Sasha's explanations made me comfortable with the 'internals' and finally lifted the 'magic veil' off the engine. 'MySQL internals' has a perfect balance of high-level explanations, and low-level code samples to help you understand the inner workings of the database.

After reading this book you should be comfortable enough to tackle the source, and you'll also have deep understanding of the storage engines and how to configure them, how the query parser works, how the optimizer decides on the execution plan, and much more. This is a must read for any DBA, or a programmer who wants to see a great example of a high-performance, reliable UNIX server.

4-0 out of 5 stars A very good book!
Sasha knows the mysql code well, and he has done a fantastic job of presenting it.This is an important book for anyone who would like an enhanced understanding of mysql, including DBAs who might need a detailed understanding of locking or replication to.And it's a must-have for anyone working on a storage engine.

5-0 out of 5 stars Provides clear insights
Sasha Pachev's UNDERSTANDING MYSQL INTERNALS: DISCOVERING AND IMPROVING A GREAT DATABASE provides clear insights into one of the most popular open source codes on the market. It comes from a former member of the MySQL development team, so offers the author's own insights into the program's creation and use, covering everything from communication protocols between client and server to the parser and optimizer that execute SQL commands, advantages and disadvantages of using threads, and more technical insights. ... Read more

20. MySQL Tutorial
by Luke Welling, Laura Thomson
Paperback: 288 Pages (2003-12-04)
list price: US$39.99 -- used & new: US$2.99
(price subject to change: see help)
Asin: 0672325845
Average Customer Review: 4.5 out of 5 stars
Canada | United Kingdom | Germany | France | Japan
Editorial Review

Product Description
A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient. ... Read more

Customer Reviews (7)

3-0 out of 5 stars Basic, very basic
I needed to get up to speed pretty quickly on MySQL. From the point of ordering this book until it arrived, I had already figured out 80 percent of the material the book covers, on my own.

I am a fan of printed material. All of the information here is available on the Net, but it is sometimes good to have a handy reference with all the material in one organized spot. It would also be good for a class of beginners, which I think this book is used for, too.

It didn't cost a lot and I'm happy to have it to grab from time to time, but I just got a real "blah" feeling flipping through it, as I felt like I knew everything it covered already.

4-0 out of 5 stars Good, Basic Overview.
This book is a very good basic overview of what MySql can do -- it gives you a little bit of information about a broad range of topics.So while the book is a good "survey course" in MySql, you will need to use additional sources to get into more complex features of MySql.

5-0 out of 5 stars My "go to" book when I have a question about MySQL
This relatively small 270 page book is packed with information you need to know if you work with MySQL databases.I'm impressed with it's efficiency and conciseness and use it as a reference all the time.

If you work with MySQL databases you'll love this book.

5-0 out of 5 stars Why Aren't All SQL Tutorial Books Like This?
I'm looking at you, Microsoft Product Writers, although you're certainly not alone.In 240 pages and 2 days I learned, easily comprehended, and retained more about the fundamentals of a SQL server than I ever did reading many of those "Introduction To..." behemoths.

The book starts with introducing you to both the product as well as database design and efficient database/table creation.Following this is an excellent overview of using MySQL and the MySQL-flavor of SQL focused on language (query language keywords, functions, etc), table types (MyISAM, InnoDB, etc), and transactions.You're reading is concluded with an excellent overview of general administration and optimization.Each section is broken down into discussion, fully-functional examples, a quiz, and to-do exercises, ensuring that you get to implement and solidify the skills you just acquired.

At the time of my writing this, the book is 4 years old, and the version of MySQL it addresses (4.x) has already been upgraded.I knew that when I purchased the book, and it doesn't matter as the fundamentals haven't changed.MySQL may have released improved GUI tools to accomplish many tasks as well as introducing additional features, but the underlying SQL language, design methods, and structure is the same, and knowing/understanding the fundamentals improves your efficiency and makes using the product easier.

As the purpose of this book is to teach you the fundamentals of database design and creation, this will not be your last purchase.But for those new to MySQL, you can not go wrong starting here, even now.

5-0 out of 5 stars Add This To Your Library
Luke Welling and Laura Thomson have the special gift of taking information, disseminating it, and making it simple to understand for everyone. This is the second book I bought from these authors (Php and MySQL Web Development) without any complaints.

It is nice to see books of this size (250 pages) at this price point coming out. Nothing is worse than those large tomes that weigh a ton and cost an arm and a leg. You should be able to get through this in a week, which is perfect for busy professionals.

This tutorial is written very clearly and does what I want from it - nail down the 80% of the necessary information needed to get work done. After each chapter there is a quiz to test your knowledge. The authors tackle both the user and administrator side of using the product. One of my favorite sections in the book is the Database Crash Course which discusses normalization.

If you are serious about using mySQL in your web projects, look to this book to get you started quickly. This book won't turn you into an immediate mySQL expert. But what it will do is give you the skills to be proficient. It was good enough to get my projects started on my website, KerryOnWorld.com. This is a top 30 book in my 15-year technical library. That is how much I like it. ... Read more

  1-20 of 100 | Next 20

Prices listed on this site are subject to change without notice.
Questions on ordering or shipping? click here for help.

site stats