| | Copyright |
| | A lifetime supply of thanks to: |
| | Chapter I. Introduction |
| | | What Is MySQL? |
| | | MySQL Versions |
| | | Primary MySQL Resources |
| | | Technical Requirements |
| | | About This Book |
| | | Is This Book for You? |
| | | Companion Web Site |
| | | Questions, Comments, or Suggestions? |
| | Chapter 1. Installing MySQL |
| | | General Installation Steps |
| | | Installing MySQL on Windows |
| | | Configuring MySQL on Windows |
| | | Installing MySQL on Macintosh |
| | | Installing MySQL on Linux |
| | | Basic Configuration Options |
| | | Upgrading MySQL |
| | Chapter 2. Running MySQL |
| | | Running MySQL on Windows and Windows NT |
| | | Running MySQL on Mac OS X |
| | | Running MySQL on Linux and Unix |
| | | Using Mysqladmin |
| | | Setting the Root User Password |
| | | Using the Mysql Client |
| | | Users and Privileges |
| | Chapter 3. Database Design |
| | | Normalization |
| | | Understanding Keys |
| | | Understanding Relationships |
| | | First Normal Form |
| | | Second Normal Form |
| | | Third Normal Form |
| | Chapter 4. Creating a MySQL Database |
| | | MySQL Data Types |
| | | Extra Column Characteristics |
| | | Introduction to Indexes |
| | | Finalizing a Table's Design |
| | | Choosing a Storage Engine |
| | | Character Sets and Collations |
| | | Creating Databases |
| | | Creating Tables |
| | | Modifying Tables |
| | Chapter 5. Basic SQL |
| | | Using Values in Queries |
| | | Inserting Data |
| | | Selecting Data |
| | | Using Conditionals |
| | | Using LIKE and NOT LIKE |
| | | Performing Joins |
| | | Sorting Query Results |
| | | Limiting Query Results |
| | | Updating Data |
| | | Deleting Data |
| | Chapter 6. MySQL Functions |
| | | Text Functions |
| | | Concatenation and Aliases |
| | | Numeric Functions |
| | Chapter 7. MySQL and PHP |
| | | Connecting to MySQL and Selecting a Database |
| | | Executing Simple Queries |
| | | Retrieving Query Results |
| | | Using mysqli_insert_id() |
| | | Error Handling |
| | | Security Considerations |
| | Chapter 8. MySQL and Perl |
| | | Installing Perl with MySQL Support on Windows |
| | | Installing Perl Support for MySQL on Unix and Mac OS X |
| | | Testing Perl and MySQL |
| | | Connecting to MySQL |
| | | Retrieving Query Results |
| | | Executing Simple Queries |
| | | Retrieving the Insert ID |
| | | Error Handling |
| | | Security Considerations |
| | | Using Prepared Statements |
| | Chapter 9. MySQL and Java |
| | | Installing Java Support for MySQL |
| | | Connecting to the Database |
| | | Executing Simple Queries |
| | | Retrieving Query Results |
| | | Retrieving the Insert ID |
| | | Using Prepared Statements |
| | Chapter 10. Advanced SQL and MySQL |
| | | Performing Transactions |
| | | Full-Text Searching |
| | | Regular Expressions |
| | | User-Defined Variables |
| | | Introducing Unions |
| | Chapter 11. MySQL 5 Features |
| | | Stored Routines |
| | | Using OUT Parameters |
| | | Triggers |
| | | Views |
| | Chapter 12. Techniques for Programming |
| | | Storing and Retrieving Binary Data |
| | | Making Query Result Pages |
| | | Using Transactions with Perl |
| | Chapter 13. MySQL Administration |
| | | The MySQL Administrator |
| | | Backing Up Databases |
| | | Importing Data |
| | | MySQL Logging |
| | | Database Maintenance |
| | | Improving Performance |
| | | Using Batch Files |
| | Appendix A. Troubleshooting |
| | | Installation |
| | | Starting MySQL |
| | | Accessing MySQL |
| | | mysql.sock Problems |
| | | Queries That Return Strange Results |
| | | Authentication Protocol Problems |
| | | Resetting the Root Password |
| | Appendix B. SQL and MySQL References |
| | | Basic SQL |
| | | ALTER Commands |
| | | SQL Clauses |
| | | MySQL Privileges |
| | | MySQL Data Types |
| | | MySQL Functions |
| | | Other References |
| | Appendix C. Resources |
| | | MySQL-Specific |
| | | Third-Party MySQL Applications |
| | | SQL |
| | | PHP |
| | | Perl |
| | | Java |
| | | Other |
| | Index |