Learning MySQL
Get a Handle on Your Data
Publisher: O'Reilly Media
Final Release Date: November 2006
Pages: 622

Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful 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 ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data.



After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-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 thePHP and Perl programming languages


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



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

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyLearning MySQL
 
3.5

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (4)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (2)

  • 1 Stars

     

    (0)

Reviewed by 8 customers

Sort by

Displaying reviews 1-8

Back to top

 
5.0

Well-Rounded Introduction to MySQL

By LinuxBoy

from Riverside, CA

About Me Designer, Developer, Sys Admin

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate
    • Novice

    Comments about oreilly Learning MySQL:

    I have enjoyed reading this book and using it as a tutorial. The authors also include many helpful PHP examples. Of course, there are other advanced MySQL books out there, but this one is written for a general audience and for those just learning MySQL and SQL. Ultimately, it's a well written and organized guide for anyone who wants to jump into MySQL and learn from many practical code examples provided by the authors.

    (2 of 2 customers found this review helpful)

     
    4.0

    Title Describes It Well

    By Tom C

    from Fairhope, AL

    About Me Designer, Developer, Educator

    Verified Reviewer

    Pros

    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Novice
      • Student

      Comments about oreilly Learning MySQL:

      A very clear book if you are either brand new to SQL or to MySQL. A reader who completes most of this book should be in good shape to start using MySql especially with PHP.

      (0 of 12 customers found this review helpful)

       
      4.0

      A book to NOT to avoid?

      By canit0

      from Undisclosed

      Comments about oreilly Learning MySQL:

      If you're an advanced MySQL user why would you buy a beginners book, less alone purchase a book if you're looking to learn or code specific language to interact with it?

      (4 of 5 customers found this review helpful)

       
      4.0

      Very Good Book

      By canit0

      from Undisclosed

      Comments about oreilly Learning MySQL:

      This book is very good for beginners wanting to learn MySQL. As noted earlier by other readers this book is not for advanced MySQL users nor web developers looking to learn specific language for interaction with MySQL; therefore, it is unfair to give this book an average review because of lack of research.

      (0 of 1 customers found this review helpful)

       
      4.0

      Very Good

      By Anonymous

      from Undisclosed

      Comments about oreilly Learning MySQL:

      That's a good book, not for advanced SQL programmers though.

      Easy to understand with great examples. I would recommend this book if you are starting to learn MySQL or are a intermediate programmer and needs a good database like MySQL. This book can be a reference for your studies. If I had this book before I could spent less time learning MySQL. But I probably would not recommend for heavy advanced SQL users, since the book have an overall idea of the SQL commands and some linux/php/database coding. Digg in!

      (3 of 7 customers found this review helpful)

       
      2.0

      A book to avoid?

      By joshSVUG

      from Undisclosed

      Comments about oreilly Learning MySQL:

      If you are a web developer looking to get started working with MySQL as your back-end database, you're probably better off getting a book which is focused on your language of choice.

      If you are an experienced database developer or DBA, you're probably better off Google-ing around or just lurking on the MySQL DEV website (http://dev.mysql.com/). This book won't teach you anything you don't know (or can't find elsewhere).

      If you are a novice web/DB developer, and you purchase this book, proceed with caution. I found the book to be incomplete; there is no mentioning of stored procedures, minimal discussion around transactions (what about SAVEPOINTs?), and when in Chapter 8 "Doing More with MySQL" the authors mention the use of functions "to meet more complex information needs" they mention only the RAND() function?! What about IFNULL()/NULLIF() , CASE, just to name a few.

      I also found a few "accidents waiting to happen": when teaching about creating indexes, why would one want to DROP the table you're working with and recreate it with a "KEY" (pages 204-5) and only introduce the ALTER TABLE/ADD INDEX on page 217. Read (to the end) before you execute!

      If you bought this book, you should probably buy MySQL Stored Procedure Programming By Guy Harrison, Steven Feuerstein (O'Reilly) to get a better picture of MySQL.

      (1 of 1 customers found this review helpful)

       
      2.0

      Defeated by a bad index

      By Barton

      from Undisclosed

      Comments about oreilly Learning MySQL:

      The text of the book is clear and informative, however I keep getting bamboozled by the index. I look for things in the index that I know are in the book, and I can't find them. This means that the book is a decent tutorial, but falls down as a reference book.

      (1 of 1 customers found this review helpful)

       
      3.0

      Not bad, but not best out there

      By John Joyce

      from Undisclosed

      Comments about oreilly Learning MySQL:

      This is a good book, maybe as a reference. The first 3 or 4 chapters are vital reading. A bit dry though, who only works on a database without any other software? This isn't 1980.

      None the less, if you're learning PHP, Rails or what have you, this needs to be on your bookshelf.

      It does answer some questions about MySQL that never get answered elsewhere.

      Displaying reviews 1-8

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook: $35.99
      Formats:  DAISY, ePub, Mobi, PDF
      Print & Ebook: $49.49
      Print: $44.99