Tutorial: MySQL

Please select a chapter from the "Contents" menu at the very bottom of the page.

MySQL

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