Home > Store > Databases > SQL Server
MySQL, 4th Edition
- By Paul Dubois
- Published Aug 29, 2008 by Addison-Wesley Professional. Part of the Developer's Library series.
- Copyright 2009
- Dimensions: 7x9
- Pages: 1224
- Edition: 4th
- Book
- ISBN-10: 0-672-32938-7
- ISBN-13: 978-0-672-32938-8
Register your product to gain access to bonus material or receive a coupon.
Register your book and gain access to the online appendixes. Log in and enter the book's ISBN, then a link to the content will be listed on your Account page, under Registered Products.
Product Author Bios
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.
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
Introduction 1
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
Index 1225
|
9 of 9 people found the following review helpful
This is a reference book, by the same person who writes the online documentation., By
Amazon Verified Purchase(What's this?)
This review is from: MySQL (4th Edition) (Paperback)
While this book is a comprehensive, I found it to be more of a reference book than otherwise. It covers pretty much the same material as what is found in the online docs. Which isn't surprising as the book author is an employee of MySQL and writes the online documentation. The book is valuable as a reference, but it weighs in at 1200 pages which is more than I am going to sit down and read as a narrative.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. Greg
4 of 4 people found the following review helpful
Excellent Book, By Eric (Seattle WA) - See all my reviews
Amazon Verified Purchase(What's this?)
This review is from: MySQL (4th Edition) (Paperback)
This book has been super useful. I was new to development with MySQL and among the 3 or 4 MySQL books I got, this is the go-to book I use. It's very thorough, explains things clearly, and has lots of concise examples to show statements in use. Highly recommend it.
15 of 20 people found the following review helpful
No usable index!, By John H. Hardin (Lahaina, HI USA) - See all my reviews
Amazon Verified Purchase(What's this?)
This review is from: MySQL (4th Edition) (Developer's Library) (Kindle Edition)
This review is specifically for the Kindle edition.After receiving the download of this ebook, I was astounded to find that the index was just a list of terms with no link to the actual location in the book where the topic is discussed. This is not true of all Kindle books, because MySQL High Availability from O'Reilly, which I also purchased on the Kindle recently, does have a working index where each item is a hot link into the book. The pagination of a Kindle book varies by the font selected, so I can understand removing page numbers from the index. But then you have to make the items links, like you have in the Table of Contents. I would caution anyone interested in the Kindle version of this book to consider whether they can use a 1200+ page book of technical information without an index. I have to wonder if this no-index policy is true of the other books from this publisher. I don't know how to find out without first buying the book for the Kindle. |
Online Sample Chapter
Table of Contents
Introduction 1
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
Index 1225
Sample Pages
Book
This product currently is not for sale.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
