MySQL: Visual QuickStart Guide (2nd Edition)-->Table of Contents
- Introduction
- 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 Dtaa
- 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
- Date and Time Functions
- Formatting the Date and Time
- Encryption Functions
- Grouping Functions
- Other Functions
- Chapter 7: MySQL and PHP
- Connecting to MySQL and Selecting a Database
- Executing Simple Queries
- Retrieving Query Results
- Using mysql_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
Search This Book!
Newsletter #25 Sent!
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(February 2, 2010)
Newsletter #24 Released
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(December 17, 2009)
New Blog Series on the Yii Framework
I've been writing a series of articles on the Yii framework for PHP Web development. There are currently seven posts, taking you from start to finish of the development process, with more to come.(November 12, 2009)
