Book description
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
.
Table of contents
- Title Page
- Copyright Page
- Developer’s Library
- Contents at a Glance
- Table of Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
-
Part I: General MySQL Use
- 1. Getting Started with MySQL
-
2. Using SQL to Manage Data
- 2.1. The Server SQL Mode
- 2.2. MySQL Identifier Syntax and Naming Rules
- 2.3. Case Sensitivity in SQL Statements
- 2.4. Character Set Support
- 2.5. Selecting, Creating, Dropping, and Altering Databases
- 2.6. Creating, Dropping, Indexing, and Altering Tables
- 2.7. Obtaining Database Metadata
- 2.8. Performing Multiple-Table Retrievals with Joins
- 2.9. Performing Multiple-Table Retrievals with Subqueries
- 2.10. Performing Multiple-Table Retrievals with UNION
- 2.11. Multiple-Table Deletes and Updates
- 2.12. Performing Transactions
- 2.13. Foreign Keys and Referential Integrity
- 2.14. Using FULLTEXT Searches
- 3. Data Types
- 4. Views and Stored Programs
- 5. Query Optimization
-
Part II: Using MySQL Programming Interfaces
- 6. Introduction to MySQL Programming
-
7. Writing MySQL Programs Using C
- 7.1. Compiling and Linking Client Programs
- 7.2. Connecting to the Server
- 7.3. Handling Errors and Processing Command Options
- 7.4. Processing SQL Statements
- 7.5. An Interactive Statement-Execution Program
- 7.6. Writing Clients That Include SSL Support
- 7.7. Using Multiple-Statement Execution
- 7.8. Using Server-Side Prepared Statements
- 7.9. Using Prepared CALL Support
- 8. Writing MySQL Programs Using Perl DBI
- 9. Writing MySQL Programs Using PHP
-
Part III: MySQL Administration
- 10. Introduction to MySQL Administration
- 11. The MySQL Data Directory
-
12. General MySQL Administration
- 12.1. Securing a New MySQL Installation
- 12.2. Arranging for MySQL Server Startup and Shutdown
- 12.3. Using System and Status Variables
- 12.4. The Plugin Interface
- 12.5. Storage Engine Configuration
- 12.6. Globalization Issues
- 12.7. Server Tuning
- 12.8. Server Logs
- 12.9. Running Multiple Servers
- 12.10. Updating MySQL
- 13. Security and Access Control
-
14. Database Maintenance, Backups, and Replication
- 14.1. Principles of Preventive Maintenance
- 14.2. Performing Database Maintenance with the Server Running
- 14.3. General Preventive Maintenance
- 14.4. Making Database Backups
- 14.5. Copying Databases to Another Server
- 14.6. Checking and Repairing Database Tables
- 14.7. Using Backups for Data Recovery
- 14.8. Setting Up Replication Servers
-
Part IV: Appendixes
- A. Software Required to Use This Book
- B. Data Type Reference
- C. Operator and Function Reference
- D. System, Status, and User Variable Reference
- E. SQL Syntax Reference
-
F. MySQL Program Reference
- F.1. Displaying a Program’s Help Message
- F.2. Specifying Program Options
- F.3. myisamchk
- F.4. mysql
- F.5. mysql.server
- F.6. mysql_config
- F.7. mysql_install_db
- F.8. mysql_upgrade
- F.9. mysqladmin
- F.10. mysqlbinlog
- F.11. mysqlcheck
- F.12. mysqld
- F.13. mysqld_multi
- F.14. mysqld_safe
- F.15. mysqldump
- F.16. mysqlimport
- F.17. mysqlshow
- F.18. perror
- Index
- G. C API Reference
- H. Perl DBI API Reference
- I. PHP API Reference
Product information
- Title: MySQL, 5th Edition
- Author(s):
- Release date: April 2013
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780133038552
You might also like
book
MySQL Cookbook, 3rd Edition
MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s …
book
MySQL in a Nutshell, 2nd Edition
When you need to find the right SQL keyword or MySQL client command-line option right away, …
book
High Performance MySQL, 3rd Edition
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques …
book
MySQL 8 Cookbook
Design and administer enterprise-grade MySQL 8 solutions About This Book Store, retrieve, and manipulate your data …