|
Sitemap
BackCover
Mastering MySQL 4
Introduction
What Not to Expect from This Book
What Do You Need?
How to Use This Book
How to Contact the Author
Part I: Using MySQL
Chapter 1: Quickstart to MySQL
Understanding MySQL Basics
Connecting to the MySQL Server
Creating and Using Your First Database
Summary
Chapter 2: Data Types and Table Types
Exploring the Various Column Types
MySQL Options
Exploring the Various Table Types
Summary
Chapter 3: Advanced SQL
Operators
Advanced Joins
Adding Records to a Table from Other Tables with INSERT SELECT
More about Adding Records
More about Removing Records (DELETE and TRUNCATE)
User Variables
Running SQL Statements Stored in files
Transactions and Locking
Summary
Chapter 4: Indexes and Query Optimization
Understanding Indexes
Creating an Index
Using an Auto Increment Field
Dropping or Changing an Index
Understanding Table Types and Indexes
Using Indexes Effectively
Analyzing How MySQL Uses Indexes with EXPLAIN
Optimizing Selects
Optimizing Updates, Deletes, and Inserts
Summary
Chapter 5: Programming with MySQL
Using Good Database Programming Techniques
The Stages of Application Development
Summary
Chapter 6: Extending MySQL
User-Defined Functions
Troubleshooting the UDF
Summary
Part II: Designing a Database
Chapter 7: Understanding Relational Databases
Exploring Early Database Models
Understanding the Relational Database Model
Summary
Chapter 8: Database Normalization
Understanding Normalization
Understanding Denormalization
Summary
Chapter 9: Database Design
The Database Lifecycle
Real-World Example: Creating a Publishing Tracking System
Concurrency Control with Transactions
Summary
Part III: MySQL Administration
Chapter 10: Basic Administration
Meeting MySQL as an Administrator
Starting and Shutting Down MySQL
Configuring MySQL
Logging
Optimizing, Analyzing, Checking, and Repairing Tables
Summary
Chapter 11: Database Backups
Backing Up MyISAM Tables with BACKUP
Restoring MyISAM Tables with RESTORE
Backing Up MyISAM Tables by Directly Copying the files
Backing Up with mysqldump
Backing Up with SELECT INTO
Using mysqlhotcopy to Back Up
Using the Binary Update Log to Restore a Database to the Most Recent Position
Backing Up and Restoring InnoDB Tables
Replication as a Means of Backup
Summary
Chapter 12: Database Replication
Understanding Replication
Setting Up Replication
Replicating One Database
Replicating with an Active Binary Log on the Master
Removing Old Binary Logs from the Master and Then Starting
Avoiding Too Many Updates
Avoiding Key Errors
Summary
Chapter 13: Configuring and Optimizing MySQL
Optimizing the mysqld Variables
Changing Variable Values with the Server Running
Improving Hardware to Speed Up the Server
Using Benchmarks
Running MySQL in ANSI Mode
Using Different Languages in MySQL
Chapter 14: Database Security
Security When Connecting
Managing Users and Permissions
SSL Connections
Application Security
System Security
Security Issues with LOAD DATA LOCAL
Summary
Chapter 15: Installing MySQL
Deciding Whether to Install a Source or Binary Distribution
Installing MySQL on Windows
Installing MySQL on Unix
Installing Multiple MySQL Servers on the Same Machine
Avoiding Common Installation Problems
Upgrading from MySQL 3.x to MySQL 4
Summary
Chapter 16: Multiple Drives
Understanding RAID
Using Symbolic Links
Summary
Part A: Appendixes
Appendix A: MySQL Syntax Reference
ALTER
ANALYZE TABLE
BACKUP TABLE
BEGIN
CHECK TABLE
COMMIT
CREATE
DELETE
DESC
DESCRIBE
DO
DROP
EXPLAIN
FLUSH
GRANT
INSERT
JOIN
KILL
LOAD DATA INFILE
LOCK TABLES
OPTIMIZE
RENAME
REPAIR TABLE
REPLACE
RESET
RESTORE TABLE
REVOKE
ROLLBACK
SELECT
SET
SET TRANSACTION
SHOW
TRUNCATE
UNION
UNLOCK TABLES
UPDATE
USE
Appendix B: MySQL Function and Operator Reference
Arithmetic Operators
Comparison Operators
Bit Operators
Date and Time Functions
String Functions
Numeric Functions
Aggregate Functions
Other Functions
Appendix C: PHP API
PHP MySQL Functions
Appendix D: Perl DBI
DBI Class Methods
DBI Methods Common to All Handles
DBI Utility Functions
Database Handle Methods
Statement Handle Methods
DBI Attributes Common to All Handles
Database Handle Attributes
Statement Handle Attributes
Dynamic Attributes
A Short Perl DBI Example
Appendix E: Python Database API
Attributes
Methods
A Short Python Example
Appendix F: Java API
General Methods
Connection Methods
Statement and Prepared Statement Methods
ResultSet Methods
ResultSetMetaData Methods
SQLException Methods
Warning Methods
A Short Java Example
Appendix G: C API
C API Functions
A Short C API Example
Appendix H: ODBC and .NET
Understanding Data Sources
Exporting Data from Microsoft Access to MySQL
Using ODBC
MyODBC Functions
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_Y
Index_Z
List of Figures
List of Tables
List of Listings
List of Sidebars
|