16 Reviews
|
5 star:
|
|
(11) |
|
4 star:
|
|
(5) |
|
3 star:
|
|
(0) |
|
2 star:
|
|
(0) |
|
1 star:
|
|
(0) |
| | | |
|
|
Average Customer Review
Share your thoughts with other customers
Create your own review
|
|
|
|
|
Most Helpful First | Newest First
|
|
|
14 of 15 people found the following review helpful:
5.0 out of 5 stars
Got to be THE definitive MySQL book, 11 Jun 2001
By A Customer
I found myself having to use MySQL to backend a C-based project I was doing, but I'd not seen MySQL before. Used this book along with the online manual and had the application working great (with replication!) in about three days. Just added a web-based PHP front end too. All this is documented in this book, very clear and easy to follow. Problems? - if you don't know SQL, get a SQL reference as well, and the book is a bit out of date, which is normal with computer software books. Oh, and it's a bit on the pricy side.. Summary: in my opinion this book is as definitive on MySQL as K&R is/was on the C language. Get it!
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
8 of 9 people found the following review helpful:
4.0 out of 5 stars
The best MySQL book I purchased, 1 Mar 2003
By A Customer
In the second edition of MySQL, Paul DuBois provides an updated, comprehensive guide to one of the most popular relational database systems.
MySQL 4.0, now generally available, is a long-awaited update to the database management system that has many new features, including a new table definition file format, enhanced replication, and more functions for a full text search. I am impressed by the clarity and usefulness of the introductory chapters that are targeted at readers new to databases. This section gives non-technical users the knowledge and experience needed to make productive use of a database very quickly.
The book make the learning for beginners piece of cake, and for experienced ones a lot of fun. It's focus is on couple of tables that you build in the first chapter, and keep manipulating throughout the book.
Easy language, great references and awesome appendixes. Listings of all the functions, keywords, syntaxes are available (in alphabetical order). Also separate appendixes for Perl DBI API, C API and PHP API makes it even more useful...
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
2 of 2 people found the following review helpful:
5.0 out of 5 stars
MySQL - A slightly non technical review of a technical manual, 23 Mar 2010
This review is from: MySQL (Developer's Library) (Paperback)
This book is heavy going. At 1224 pages it will be used more as a reference manual than a book that you will read from start to finish. The book introduces itself nicely rather than jumping straight in, making it an ideal companion for users at all levels.
In simple terms, the book explains how to get your data into the database and then how to ask the right questions to retrieve selected records from the database (known as queries). The structure of the book has been well thought out, being broken down into 4 distinct sections, with each section being broken down into chapters. This format should make it easier to find the exact subject you need to research.
The breakdown in more detail is :-
Part 1 : General MySQL Use
This is a nice slow introduction into SQL. If you are new to the concept of relational databases (for those of you who use Microsoft Office, Access is also a relational database) and SQL, this section will give you a broad understanding of the language and the confidence to progess to further stages.
* Chapter 1, "Getting Started with MySQL and SQL". This chapter is more of an introduction to SQL in general and introduces the MySQL client program which will be used to write queries against the database.
* Chapter 2, "Working with data in MySQL". This chapter discusses how the database tables are created along with what types of fields can be created.
* Chapter 3, "MySQL syntax and use", This chapter discusses the SQL language and how MySQL varies from other forms of SQL.
* Chapter 4, "Query Optimisation". This chapter discusses how to make your queries run faster.
Part 2 : Using the MySQL programming interfaces
This section of the book is very technical so I'll just provide a summary so as not to lose half of the audience of the review. The book covers interfacing with many of the common web languages such as Perl, C and php. I would recommend that database and/or programming novices skip this section completely. If you have got a programming background and need to know how to interface with any of these languages, this section of the book gives you a good understanding of how to do this well and includes lots of code examples to back up this theory.
Part 3 : MySQL Administration
This part of the book looks at the role of the database administrator. This part, is one of the most important in the book as database security is paramount to any application so I would recommend that if you do read this book, your understanding of the content here is clear. Again, the author approaches this section in a nice structured manner and the chapters are well structured and relevant to what it trying to be achieved.
* Chapter 9, ""Introduction to MySQL Administration"". This chapter explains what the database administrator's duties are and what you should know to run a site successfully.
* Chapter 10, "The MySQL Data Directory". The data directory is the actual area where all of your database files are stored. This chapter provides an understanding of how the directory works.
* Chapter 11, "General MySQL Administration". This chapter discusses the setting up of user accounts and maintaining log files which are used if you need to roll the database back to an earlier state. In my opinion, this chapter is pretty heavy going but luckily, its something that you don't need to do too often.
* Chapter 12, "Security". In my opinion, one of the most crucial chapters in the book. We learn how to make the database safe from intruders and how to make the database safe over the internet by using encryption.
* Chapter 13, "Database Backups, Maintenance and Repair". Again, another crucial chapter in my opinion. The author discusses various scenarios and the best techniques to recover your data in the unfortunate event of a disaster (any loss of data in computing terms is referred to as a disaster). This chapter does deal with worst case scenarios but I feel that after reading and understanding this content, you will gain peace of mind that, should the worst happen, restoring data will not be an arduous task.
Part 4 : Appendices
There are 9 appendices which, to be truthful are only for the technically minded out there who wish to take the database to the nth degree. If reading about database column types and different programming languages excites you then you will spend many a happy hour trawling through the appendix. As I am trying to keep this review relevant to a wider audience, I am not going to go into detail here as it wont really give you a better understanding of the book.
The Verdict
This is the first book I have bought on MySQL. I usually tend to steer clear of technical books as I find that you can get more relevant and upto date information off the web and in particular, forums. I found the book to be at just the level I needed in terms of the functions I needed to perform. Having knowledge of SQL itself, I was pleased that the book didn't go over ground that I already knew in much detail, although it did touch the surface for the benefit of completely new users.
As someone who likes to delve straight in to writing queries, my only major gripe with the book is that there is a lot of theory and explanations of techniques before actually getting down to the nitty gritty of examples. In my opinion, examples are a lot easier for grasping the concept of a technique than reading paragraph after paragraph of text. Maybe this is an unfair criticism as other people might prefer the theoretical approach.
My only other downer with the book is that it goes into too much detail in the middle sections about various programming languages which, in my opinion is bordering with going out of scope as to what this book is about. In my opinion, if you want to know how to program Perl to make use of MySQL, then you buy a Perl book. I appreciate that its nice to know that you can perform these kinds of functions but I think this book goes into too much detail for my liking.
If you need a specific MySQL book then this one covers all aspects of the database in great detail. The MySQL syntax isn't a million miles from the Microsoft SQL server syntax so if all you wish to do is the query writing then any book on Microsoft SQL server will be adequate if you can find ones cheaper than this. As for understanding how to back up your databases, this book is an essential aid and for that reason alone I would recommend this book wholeheartedly.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
2 of 2 people found the following review helpful:
5.0 out of 5 stars
Pretty complete book on MySQL, 7 Jun 2000
By A Customer
This book is one of the most complete book on MySQL. I wish I had it earlier before buying O'Reilly's mSQL/MySQL. Although O'Reilly's is good (with quite a lot of errata) overview of mSQL and MySQL, this book covers MySQL in more details, down to some scripts/tips that you can use while writing your SQL statements. Optimizing your query is also mentioned, plus interfacing MySQL with C, Perl and Php (why no Java?).If you want a good book on MySQL, this is the one.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
1 of 1 people found the following review helpful:
5.0 out of 5 stars
Excellent , Clearly written .....First Class, 13 Aug 2009
This review is from: MySQL (Developer's Library) (Paperback)
This is probably the best written technical book I have ever seen.
The exceptionally clear technical writing should serve as an example to every other technical author.
The fourth edition,being recently printed, is reasonably up to date, with even .the 'C' examples ( under linux) often working first time, without too many changes, typos,or compatibility problems.
First class.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
1 of 1 people found the following review helpful:
4.0 out of 5 stars
delightful, 7 Mar 2000
By A Customer
A clear insight into MySql. Saved me having to print out the online documentation
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
5 of 6 people found the following review helpful:
5.0 out of 5 stars
An excellent book - probably the only MySQL book needed, 7 Mar 2001
By A Customer
Having embarked up on a large project for my Company, utilising both PHP and MySQL I found this book a godsend.You need to have some experience of programming but the book is laid out so concisely and precisely that you will find that even seemingly complex theories and procedures become simple. As well as PHP there are excellent chapters on how to access MySQL from both C and Perl, using the DBI
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
5.0 out of 5 stars
Probably the only book you need on MySQL, 6 April 2009
This review is from: MySQL (Developer's Library) (Paperback)
This is the only book I've ever read on MySQL and I've never needed anything else. It's a tutorial and a reference guide; it includes comprehensive coverage of the MySQL APIs for C, Perl and PHP (in my edition; possibly other languages are covered in later editions); it tells you where to get the software.
Even though SQL is a simple language, its structure is different from programming languages, and the tutorial leads you through its concepts and syntax at a gentle pace, but thoroughly. Meanwhile, the reference sections are models of clarity and I come back to them again and again.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
5.0 out of 5 stars
The best book available of the subject of MySQL, 27 Jun 2000
Paul, I would truely like to congratulate you on such complete and comprehensive coverage of MySQL. For people who don't know Paul is a frequent contributor to both the support mail list and the development of MySQL. Paul's book is suitable to all skill levels and is written in a style that can be understood by all. I highly recommend Paul's to anybody interested in using and/or programming MySQL
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
2 of 3 people found the following review helpful:
5.0 out of 5 stars
Database programming made easy, 29 Aug 2003
By A Customer
This is one of the most accessible books you could want to read if you want to get going with MySQL databases. From no database experience at all, this book helped me create interactive web pages in conjunction with PHP (though PERL and C are supported as well). The theory is explained but the examples are excellent and can be adapted for your own requirements. Major features of MySQL theory are explained but items such as database recovery, query optimistation and general database administration are covered as well.
I would recommend purchasing this book in conjunction with Luke Welling and Laura Thompson 'PHP and MySQL development' and you'll be amazed at what you'll be doing in a short space of time.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
| | |
|
|
|
|
|
Most Helpful First | Newest First
|
|
|
