| |
| |
| Preface | |
| |
| |
| |
| General Information | |
| |
| |
| |
| About This Manual | |
| |
| |
| |
| What Is MySQL? | |
| |
| |
| |
| What Is MySQL AB? | |
| |
| |
| |
| MySQL Support and Licensing | |
| |
| |
| |
| MySQL 4.0 in a Nutshell | |
| |
| |
| |
| MySQL Information Sources | |
| |
| |
| |
| How Standards-Compatible Is MySQL? | |
| |
| |
| |
| MySQL and the Future (the TODO) | |
| |
| |
| |
| How MySQL Compares to Other Databases | |
| |
| |
| |
| MySQL Installation | |
| |
| |
| |
| Quick Standard Installation of MySQL | |
| |
| |
| |
| General Installation Issues | |
| |
| |
| |
| Installing a MySQL Source Distribution | |
| |
| |
| |
| Post-Installation Setup and Testing | |
| |
| |
| |
| Upgrading/Downgrading MySQL | |
| |
| |
| |
| Operating System-Specific Notes | |
| |
| |
| |
| Perl Installation Comments | |
| |
| |
| |
| Tutorial Introduction | |
| |
| |
| |
| Connecting to and Disconnecting from the Server | |
| |
| |
| |
| Entering Queries | |
| |
| |
| |
| Creating and Using a Database | |
| |
| |
| |
| Getting Information About Databases and Tables | |
| |
| |
| |
| Examples of Common Queries | |
| |
| |
| |
| Using mysql in Batch Mode | |
| |
| |
| |
| Queries from Twin Project | |
| |
| |
| |
| Using MySQL with Apache | |
| |
| |
| |
| Database Administration | |
| |
| |
| |
| Configuring MySQL | |
| |
| |
| |
| General Security Issues and the MySQL Access Privilege System | |
| |
| |
| |
| MySQL User Account Management | |
| |
| |
| |
| Disaster Prevention and Recovery | |
| |
| |
| |
| Database Administration Language Reference | |
| |
| |
| |
| MySQL Localisation and International Usage | |
| |
| |
| |
| MySQL Server-Side Scripts and Utilities | |
| |
| |
| |
| MySQL Client-Side Scripts and Utilities | |
| |
| |
| |
| The MySQL Log Files | |
| |
| |
| |
| Replication in MySQL | |
| |
| |
| |
| MySQL Optimisation | |
| |
| |
| |
| Optimisation Overview | |
| |
| |
| |
| Optimising SELECTs and Other Queries | |
| |
| |
| |
| Locking Issues | |
| |
| |
| |
| Optimising Database Structure | |
| |
| |
| |
| Optimising the MySQL Server | |
| |
| |
| |
| Disk Issues | |
| |
| |
| |
| MySQL Language Reference | |
| |
| |
| |
| Language Structure | |
| |
| |
| |
| Column Types | |
| |
| |
| |
| Functions for Use in SELECT and WHERE Clauses | |
| |
| |
| |
| Data Manipulation: SELECT, INSERT, UPDATE, DELETE | |
| |
| |
| |
| Data Definition: CREATE, DROP, ALTER | |
| |
| |
| |
| Basic MySQL User Utility Commands | |
| |
| |
| |
| MySQL Transactional and Locking Commands | |
| |
| |
| |
| MySQL Full-Text Search | |
| |
| |
| |
| MySQL Query Cache | |
| |
| |
| |
| MySQL Table Types | |
| |
| |
| |
| MyISAM Tables | |
| |
| |
| |
| MERGE Tables | |
| |
| |
| |
| ISAM Tables | |
| |
| |
| |
| HEAP Tables | |
| |
| |
| |
| InnoDB Tables | |
| |
| |
| |
| BDB or Berkeley_DB Tables | |
| |
| |
| |
| MySQL APIs | |
| |
| |
| |
| MySQL PHP API | |
| |
| |
| |
| MySQL Perl API | |
| |
| |
| |
| MySQL ODBC Support | |
| |
| |
| |
| MySQL C API | |
| |
| |
| |
| MySQL C++ APIs | |
| |
| |
| |
| MySQL Java Connectivity (JDBC) | |
| |
| |
| |
| MySQL Python APIs | |
| |
| |
| |
| MySQL Tcl APIs | |
| |
| |
| |
| MySQL Eiffel Wrapper | |
| |
| |
| |
| Extending MySQL | |
| |
| |
| |
| MySQL Internals | |
| |
| |
| |
| Adding New Functions to MySQL | |
| |
| |
| |
| Adding New Procedures to MySQL | |
| |
| |
| |
| Problems and Common Errors | |
| |
| |
| |
| Contributed Programs | |
| |
| |
| |
| Credits | |