| ||||||||||||||||||
Produits fréquemment achetés ensemble
Détails sur le produit
Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?
|
En savoir plus sur les auteurs
Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Commentaires en ligne
If you're already somewhat familiar with MySQL, this book is a great reference for the SQL and database manipulation you already know how to do. In addition, the examples push the envelope of what is possible with MySQL making it a good learning tool for becoming truly expert.
Some of the information in the book I found useful includes:
- simplifying complex SQL using temporary tables.
- using FULLTEXT searches (similar to pattern matching but more efficient and easier to code when you're looking for the same text in several columns at the same time).
- effective use of LEFT JOIN's for finding rows in one table that don't have a match in another table.
- effective use of LAST_INSERT_ID( fieldName + 1 ) for transactionally updating a numeric field without using transactions and without locking a table.
- numbering output rows using SQL variables (select @rownum := @rownum + 1; (see chapter 13.9))
I really can't say enough good things about this book. It's comprehensive, easy to read and just plain awesome.
This is book was my first introduction to O'Reilly's cookbook series. It provides solutions to some of the most common challenged faced by the particular subject being covered (in this case MySQL). I thoroughly enjoyed it and was quiet impressed with it. Too many technical books simply introduce the concept without relating it to real world applications.
This particular book introduces all of the most basic concepts of database manipulation (table creation, data insertion, data deletion, data update). As well as writing simple and advanced SQL statements to retrieve data. It approaches database design using 4 of the most popular languages (Perl, PHP, Python and Java). These are only a few of the many possible languages which can be used to manipulate a MySQL database.
MySQL cookbook touches on a variety of different topics which I don't have the space or time to cover in detail, but here is a list of them:
* Handeling duplicates
* MySQL on the Web
* Processing Web input with MySQL
* Using MySQL-based Web Session Management
One of my favorite topics covered in the book is the idea of storing binary data such as images within a database. Although not ideal for most cases (unless you need fast access to a vast array of images), just the idea of it has a certain kewlness effect.
Well, overall I give it 4 out of 5 stars. It needs to touch slightly more on the basic concepts of databases, and it can become the only book you'll ever need for MySQL.
Listmania!
Rechercher des articles similaires par rubrique
Commentaires
|
