| MySQL, Second Edition |
| By Paul DuBois |
| | |
| Publisher | : Sams |
| Pub Date | : January 17, 2003 |
| ISBN | : 0-7357-1212-3 |
| Pages | : 1248 |
| Copyright |
| | | About the Author |
| | | About the Technical Reviewers |
| | | Acknowledgments |
| | | | First Edition |
| | | | Second Edition |
| |
| | | Tell Us What You Think |
| | | Introduction |
| | | | Why Choose MySQL? |
| | | | Already Running Another RDBMS? |
| | | | Tools Provided with MySQL |
| | | | What You Can Expect from This Book |
| | | | Road Map to This Book |
| | | | How to Read This Book |
| | | | Versions of Software Covered in This Book |
| | | | Conventions Used in This Book |
| | | | Additional Resources |
| |
| | | Part I: General MySQL Use |
| | | | Chapter 1. Getting Started with MySQL and SQL |
| | | | How MySQL Can Help You |
| | | | A Sample Database |
| | | | Basic Database Terminology |
| | | | A MySQL Tutorial |
| | | | Tips for Interacting with mysql |
| | | | Where to Now? |
| |
| | | | Chapter 2. Working with Data in MySQL |
| | | | MySQL Data Types |
| | | | MySQL Column Types |
| | | | Working with Sequences |
| | | | Character Set Support |
| | | | Choosing Column Types |
| | | | Expression Evaluation and Type Conversion |
| |
| | | | Chapter 3. MySQL SQL Syntax and Use |
| | | | MySQL Naming Rules |
| | | | Selecting, Creating, Dropping, and Altering Databases |
| | | | Creating, Dropping, Indexing, and Altering Tables |
| | | | Getting Information about Databases and Tables |
| | | | Retrieving Records from Multiple Tables |
| | | | Multiple-Table Deletes and Updates |
| | | | Performing Transactions |
| | | | Foreign Keys and Referential Integrity |
| | | | Using FULLTEXT Searches |
| | | | Writing Comments |
| | | | Features That MySQL Does Not Support |
| |
| | | | Chapter 4. Query Optimization |
| | | | Using Indexing |
| | | | The MySQL Query Optimizer |
| | | | Column Type Choices and Query Efficiency |
| | | | Loading Data Efficiently |
| | | | Scheduling and Locking Issues |
| | | | Optimization for Administrators |
| |
| |
| | | Part II: Using MySQL Programming Interfaces |
| | | | Chapter 5. Introduction to MySQL Programming |
| | | | Why Write Your Own MySQL Programs? |
| | | | APIs Available for MySQL |
| | | | Choosing an API |
| |
| | | | Chapter 6. The MySQL C API |
| | | | General Procedure for Building Client Programs |
| | | | Client 1 Connecting to the Server |
| | | | Client 2 Adding Error Checking |
| | | | Client 3 Getting Connection Parameters at Runtime |
| | | | Processing Queries |
| | | | Client 4 An Interactive Query Program |
| | | | Writing Clients That Include SSL Support |
| | | | Using the Embedded Server Library |
| | | | Miscellaneous Topics |
| |
| | | | Chapter 7. The Perl DBI API |
| | | | Perl Script Characteristics |
| | | | Perl DBI Overview |
| | | | Putting DBI to Work |
| | | | Using DBI in Web Applications |
| |
| | | | Chapter 8. The PHP API |
| | | | PHP Overview |
| | | | Putting PHP to Work |
| |
| |
| | | Part III: MySQL Administration |
| | | | Chapter 9. Introduction to MySQL Administration |
| | | | Overview of Administrative Duties |
| | | | General Administration |
| | | | Security |
| | | | Database Repair and Maintenance |
| |
| | | | Chapter 10. The MySQL Data Directory |
| | | | Location of the Data Directory |
| | | | Structure of the Data Directory |
| | | | Relocating Data Directory Contents |
| |
| | | | Chapter 11. General MySQL Administration |
| | | | Securing a New MySQL Installation |
| | | | Arranging for MySQL Server Startup and Shutdown |
| | | | Managing MySQL User Accounts |
| | | | Maintaining Log Files |
| | | | Additional Server Configuration Topics |
| | | | Running Multiple Servers |
| | | | Setting Up Replication Servers |
| | | | Updating MySQL |
| |
| | | | Chapter 12. Security |
| | | | Internal Security: Preventing Unauthorized File System Access |
| | | | External Security: Preventing Unauthorized Network Access |
| | | | Setting Up Secure Connections |
| |
| | | | Chapter 13. Database Backups, Maintenance, and Repair |
| | | | Coordinating with the Server |
| | | | Preparing for Disaster |
| | | | Table Repair and Data Recovery |
| |
| |
| | | Part IV: Appendixes |
| | | | Appendix A. Obtaining and Installing Software |
| | | | Obtaining the sampdb Sample Database Distribution |
| | | | Obtaining MySQL and Related Software |
| | | | Installing MySQL on UNIX |
| | | | Installing MySQL on Windows |
| |
| | | | Appendix B. Column Type Reference |
| | | | Numeric Types |
| | | | String Types |
| | | | Date and Time Types |
| |
| | | | Appendix C. Operator and Function Reference |
| | | | Operators |
| | | | Functions |
| |
| | | | Appendix D. SQL Syntax Reference |
| | | | SQL Statements |
| | | | SQL Variables |
| | | | Comment Syntax |
| |
| | | | Appendix E. MySQL Program Reference |
| | | | Specifying Program Options |
| | | | libmysqld |
| | | | myisamchk and isamchk |
| | | | myisampack and pack_isam |
| | | | mysql |
| | | | mysqlaccess |
| | | | mysqladmin |
| | | | mysqlbinlog |
| | | | mysqlbug |
| | | | mysqlcheck |
| | | | mysql_config |
| | | | mysqld |
| | | | mysqld_multi |
| | | | mysqld_safe |
| | | | mysqldump |
| | | | mysqlhotcopy |
| | | | mysqlimport |
| | | | mysql_install_db |
| | | | mysql.server |
| | | | mysqlshow |
| | | | safe_mysqld |
| |
| | | | Appendix F. C API Reference |
| | | | Compiling and Linking |
| | | | C API Data Types |
| | | | C API Functions |
| |
| | | | Appendix G. Perl DBI API Reference |
| | | | Writing Scripts |
| | | | DBI Methods |
| | | | DBI Utility Functions |
| | | | DBI Attributes |
| | | | DBI Environment Variables |
| |
| | | | Appendix H. PHP API Reference |
| | | | Writing PHP Scripts |
| | | | Functions |
| |
| | | | Appendix I. Internet Service Providers |
| | | | Getting Ready to Shop for an ISP |
| | | | Assessing an ISP General Considerations |
| | | | Assessing an ISP MySQL-Specific Considerations |
| |
| |
| | | Index |