MySQL (5th Edition) (Developer's Library) and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading MySQL (5th Edition) (Developer's Library) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL (5th Edition) [Paperback]

Paul DuBois

List Price: CDN$ 51.99
Price: CDN$ 32.59 & FREE Shipping. Details
You Save: CDN$ 19.40 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Tuesday, April 22? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $25.25  
Paperback CDN $32.59  

Book Description

April 2 2013 0321833872 978-0321833877 5
MySQL, Fifth Edition by Paul DuBois
The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6


MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).

Author Paul DuBois 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 book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.

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

MySQL is an open source relational database management system (DBMS) 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. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.

Paul DuBois' MySQL, Fifth Edition, is the definitive guide to fully exploiting all the power and versatility of MySQL 5.5 and MySQL 5.6

Contents at a Glance


Part I: General MySQL Use
Chapter 1 Getting Started with MySQL
Chapter 2 Using SQL to Manage Data
Chapter 3 Data Types
Chapter 4 Views and Stored Programs
Chapter 5 Query Optimization

Part II: Using MySQL Programming Interfaces
Chapter 6 Introduction to MySQL Programming
Chapter 7 Writing MySQL Programs Using C
Chapter 8 Writing MySQL Programs Using Perl DBI
Chapter 9 Writing MySQL Programs Using PHP

Part III: MySQL Administration
Chapter 10 Introduction to MySQL Administration
Chapter 11 The MySQL Data Directory
Chapter 12 General MySQL Administration
Chapter 13 Security and Access Control
Chapter 14 Database Maintenance, Backups, and Replication

Part IV: Appendixes
Appendix A Software Required to Use This Book
Appendix B Data Type Reference
Appendix C Operator and Function Reference
Appendix D System, Status, and User Variable Reference
Appendix E SQL Syntax Reference
Appendix F MySQL Program Reference

Online Appendixes:
Appendix G C API Reference
Appendix H Perl DBI API Reference
Appendix I PHP API Reference


Frequently Bought Together

Customers buy this book with High Performance MySQL: Optimization, Backups, and Replication CDN$ 32.92

MySQL (5th Edition) + High Performance MySQL: Optimization, Backups, and Replication
Price For Both: CDN$ 65.51

Show availability and shipping details


Customers Who Bought This Item Also Bought


Product Details


Product Description

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 Oracle Corporation.


What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars  9 reviews
11 of 11 people found the following review helpful
5.0 out of 5 stars Best single MySQL Book you can buy!! June 3 2013
By David M. Stokes - Published on Amazon.com
Format:Paperback
MySQL by Paul Dubois recently was reissued in a fifth edition. I purchased my first edition of this book more than a dozen years ago and it has become heavily dog-eared, festooned with Post-Its, and hand annotated over the years. It has proven to be the `go-to' book when other books or the manuals did not explain to my satisfaction any questions that have popped up.
The author is part of the amazing MySQL Documentation Team for Oracle and certainly knows the subject. At 1,154 pages it is not light in weight nor light in detail. The chapters include `Data Types', `Writing MySQL Programs using C', `Security and Access Control', `System, Status and User Variable Reference', `Query Optimization', `Writing MySQL Programs using PHP', and `The MySQl Data Dictionary'. The layout is easy on the eyes and the examples are able to spotlight the idea being covered fully. The text itself reads easily and amazingly clear. This is the most complete single book on MySQL and the one book you would bring if you have to use MySQL on the fabled desert island that allows only one book. The book is detailed enough for gnarled DBAs to discover undiscovered gems while clear enough for a junior MySQL-er to be able to get through a rough spot.

if you run across this book in a store, head directly to chapter 13 on Security and Access Control where `How to Steal Data' provides any DBA a Steven King level horror story that will provide nightmare fodder for years to come. The author then guides you through MySQL security and provides the best details on Proxy Accounts I have found. Other chapters are equally profound and perfectly detailed.

It does cover some of the new features of MySQL 5.6 but 5.6 came out after this book was committed to publishing. This is a minor problem and should not stop anyone from getting a copy of this book in their hands ASAP.

And I apologize to Paul and his publisher for what I will do to this book in the next few years as I make notes, add Post-Its, fold corners on certain pages. This is a physically beautiful book that will look like a sea anemone as I make good use of it.
3 of 3 people found the following review helpful
2.0 out of 5 stars A dump of information like the official manual Jan. 24 2014
By Jacob - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
I am an intermediate MySQL user looking to master it. I've been using MySQL on a daily basis for years. This book is very comprehensive and thorough. However, it lacks the organization that makes a technical manual easy to read and reference. It dumps all the information on it's topics all in the same section and it doesn't break it up into beginning-intermediate-advanced. You can't read this book fluently and hope to retain much - it needs to be studied and poured over. Not the experience I hope for. If your a beginner I would recommend you look elsewhere because it is too tough and unpleasant a read, and as for the intermediate / advanced for the same reasons another book for be more useful to reference.
7 of 9 people found the following review helpful
5.0 out of 5 stars Standard July 23 2013
By Rabih - Published on Amazon.com
Format:Paperback|Verified Purchase
The defacto standard in MySQL references. The one comment I would have for this book would be to make the examples a little more relevant. No one is going to code MySQL straight through the terminal. Give some info on the GUI-based systems.
3 of 4 people found the following review helpful
5.0 out of 5 stars MySQL Bible Aug. 29 2013
By Leslie Johnson - Published on Amazon.com
Format:Paperback
In the net I found the book invaluable in understanding the inner working of MySQL for designing and building my database. This I'll keep it close at hand as I flesh out the structural details of my database and set to work at my keyboard. Later on it will serve as a primary reference on SQL syntax and query structure.
4 of 6 people found the following review helpful
5.0 out of 5 stars Lighter than a breadbasket April 23 2013
By Bulldog - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
This was a great buy for a couple of reasons. First was the price; it cost a lot less than the print edition I bought two semesters ago at the college bookstore($75). I was still using that edition because of the wealth of knowledge it has on writing SQL syntax. However for $18 dollars I thought why not; I'm tired of lugging the printed version around all the time. This was truer than I knew at the time. My kindle(the old one) weighs a heck of a lot less than the book; I get a newer version with any updates that are included; and it's as easy to find the subject area on my kindle as it is to look in the table of contents in my book.
ARRAY(0xc30a5c24)

Look for similar items by category


Feedback