- List Price$43.99
- Your price$35.19
Save $8.80 (20% off) and earn Kobo Super Points!
You'll see how many points you'll earn before checking out. We'll award them after completing your purchase.
Or, get it for 18400 Kobo Super Points!
See if you have enough points for this eBook. Sign in
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
Ratings and Reviews
Be the first to rate and review this book!
You've already shared your review for this item. Thanks!
We are currently reviewing your submission. Thanks!
by Paul DuBois
Share your thoughts
Tell readers what you thought by rating and reviewing this book.
Rate it *
Please make sure to choose a rating
Add a review* Required
How to write a great review
- Say what you liked best and least
- Describe the author's style
- Explain the rating you gave
- Use rude and profane language
- Include any personal information
- Mention spoilers or the book's price
- Recap the plot
(0) 50 characters minimum
The review must be at least 50 characters long.
The title should be at least 4 characters long.
Display Name *
Your display name should be at least 2 characters long.
Report a review
At Kobo, we try to ensure that published reviews do not contain rude or profane language, spoilers, or any of our reviewer's personal information.
Would you like us to take another look at this review?
You've successfully reported this review. We appreciate your feedback.
by Paul DuBois
Thanks for Sharing!
You submitted the following rating and review. We'll publish them on our site once we've reviewed them.
by on September 25, 2016
- Pearson Education, August 2008
- Download options:
- EPUB 2 (Adobe DRM)
You can read this item using any of the following Kobo apps and devices: