By Paul DuBois
The Definitive consultant to utilizing, Programming, and Administering MySQL 5.0 and 5.1
MySQL is an open resource relational database administration approach that has skilled an attractive development in recognition and use. recognized for its velocity and simplicity of use, MySQL has confirmed itself to be fairly well-suited for constructing database-backed web content and applications.
In MySQL, Paul DuBois offers a entire consultant to utilizing and administering MySQL successfully and productively. He describes every thing from the fundamentals of having details right into a database and formulating queries, to utilizing MySQL with Hypertext Preprocessor or Perl to generate dynamic web content, to writing your personal courses that entry MySQL databases, to administering MySQL servers.
The fourth version of this bestselling ebook has been meticulously revised and up-to-date to entirely conceal the newest good points and functions of MySQL 5.0, in addition to so as to add new insurance of good points brought with MySQL 5.1.
“One of the easiest technical books i've got learn on any subject.”
–Gregory Haley, C Vu, The organization of C & C++ Users
“A top-notch user’s consultant and reference handbook, and in my view, the one ebook you’ll desire for the day-by-day operation and upkeep of MySQL databases.”
–Eugene Kim, internet Techniques
Introduction 1
Part I: common MySQL Use
Chapter 1: Getting all started with MySQL 13
Chapter 2: utilizing SQL to regulate facts 101
Chapter three: facts forms 201
Chapter four: saved courses 289
Chapter five: question Optimization 303
Part II: utilizing MySQL Programming Interfaces
Chapter 6: advent to MySQL Programming 341
Chapter 7: Writing MySQL courses utilizing C 359
Chapter eight: Writing MySQL courses utilizing Perl DBI 435
Chapter nine: Writing MySQL courses utilizing personal home page 527
Part III: MySQL Administration
Chapter 10: advent to MySQL management 579
Chapter eleven: The MySQL info listing 585
Chapter 12: common MySQL management 609
Chapter thirteen: entry regulate and protection 699
Chapter 14: Database upkeep, Backups, and Replication 737
Part IV: Appendixes
Appendix A: acquiring and fitting software program 777
Appendix B: info sort Reference 797
Appendix C: Operator and serve as Reference 813
Appendix D: process, prestige, and person Variable Reference 889
Appendix E: SQL Syntax Reference 937
Appendix F: MySQL software Reference 1037
Note: Appendixes G, H, and that i can be found on-line and are obtainable both by way of registering this publication at informit.com/register or by way of vacationing www.kitebird.com/mysql-book.
Appendix G: C API Reference 1121
Appendix H: Perl DBI API Reference 1177
Appendix I: Hypertext Preprocessor API Reference 1207
Index 1225