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

Online Appendixes:

Appendix G C API Reference

Appendix H Perl DBI API Reference

Appendix I PHP API Reference