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 |