MySQL, Second Edition - page 1
- Visual Quickstart Guide MySQL, Second Edition
- Visual Quickstart Guide MySQL, Second Edition
- Table of Contents
- 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
