|
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
Appendix G C
API Reference
Appendix H Perl DBI API Reference
Appendix I PHP API Reference
|
|
