MySQL (Developer's Library) Paperback – 29 Aug 2008
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Customers who bought this item also bought
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
From the Back Cover
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
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
About the Author
Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh
and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Sun Microsystems.
Top customer reviews
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.
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.
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.
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.
Most helpful customer reviews on Amazon.com
The first chapter is a tutorial, but after that, it's all reference material. If that is what you are looking for, great. But if your looking for beginner/intermediate material, this is not it. The book does not cover MYSQL Workbench at all which is what the newcomer to MySQL normally uses to get started. Nobody wants to learn MySQL just from a command prompt, but this is the approach the book takes.
Why not five stars? I could use a little more detail on underlying reasons and how-tos and a little better highlighting in the text to bring out examples etc.
Look for similar items by category