MySQL (5th Edition) (Developer's Library)

MySQL (5th Edition) (Developer's Library)

MySQL, 5th variation via Paul DuBois
The definitive consultant to utilizing, programming and administering MySQL 5.5 and MySQL 5.6

MySQL presents a entire advisor to successfully utilizing and administering the MySQL database administration approach (DBMS).

Author Paul DuBois describes every thing from the fundamentals of having info right into a database and formulating queries, to utilizing MySQL with personal home page or Perl to generate dynamic web content, to writing your individual courses that entry MySQL databases, to administering MySQL servers. The e-book additionally features a finished reference part delivering unique info on MySQL’s constitution, language, syntax, and APIs.

The 5th variation of this bestselling booklet has been meticulously revised and up-to-date to entirely disguise the newest good points and functions of MySQL 5.5, in addition to so as to add new assurance of good points brought with MySQL 5.6.

MySQL is an open resource relational database administration procedure (DBMS) that has skilled a stupendous progress in acceptance and use. recognized for its pace and simplicity of use, MySQL has confirmed itself to be quite well-suited for constructing database-backed web content and purposes. MySQL runs on something from modest all of the approach as much as firm servers, and its functionality opponents any database procedure submit opposed to it.

Paul DuBois' MySQL, 5th version, is the definitive consultant to totally exploiting the entire energy and flexibility of MySQL 5.5 and MySQL 5.6

Contents at a Glance

Part I: common MySQL Use
Chapter 1 Getting all started with MySQL
Chapter 2 utilizing SQL to control Data
Chapter three facts Types
Chapter four perspectives and kept Programs
Chapter five question Optimization

Part II: utilizing MySQL Programming Interfaces
Chapter 6 advent to MySQL Programming
Chapter 7 Writing MySQL courses utilizing C
Chapter eight Writing MySQL courses utilizing Perl DBI
Chapter nine Writing MySQL courses utilizing Hypertext Preprocessor

Part III: MySQL Administration
Chapter 10 creation to MySQL management
Chapter eleven The MySQL info listing
Chapter 12 normal MySQL management
Chapter thirteen defense and entry keep watch over
Chapter 14 Database upkeep, Backups, and Replication

Part IV: Appendixes
Appendix A software program Required to exploit This ebook
Appendix B info style Reference
Appendix C Operator and serve as Reference
Appendix D approach, prestige, and consumer Variable Reference
Appendix E SQL Syntax Reference
Appendix F MySQL application Reference

Online Appendixes:

Appendix G C API Reference
Appendix H Perl DBI API Reference
Appendix I personal home page API Reference

Show sample text content

Download sample