Home Page Icon
Home Page
Table of Contents for
Colophon
Close
Colophon
by Paul DuBois
MySQL
Copyright
About the Author
About the Reviewers
Foreword
Acknowledgments
Tell Us What You Think!
Introduction
General MySQL Use
Introduction to MySQL and SQL
How MySQL Can Help You
A Sample Database
Basic Database Terminology
A MySQL Tutorial
Where to Now?
Working with Data in MySQL
MySQL Data Types
MySQL Column Types
Choosing Column Types
Expression Evaluation and Type Conversion
MySQL SQL Syntax and Use
What's Present and What's Missing in MySQL?
MySQL Naming Rules
Creating, Dropping, and Selecting Databases
Creating, Dropping, Indexing, and Altering Tables
Getting Information about Databases and Tables
Retrieving Records
Writing Comments
Solutions Miscellany
Features that MySQL Does Not Support
Query Optimization
Using Indexing
The MySQL Query Optimizer
Column Type Choices and Query Efficiency
Loading Data Efficiently
Scheduling and Locking Issues
Optimization for Administrators
Using MySQL Programming Interfaces
Introduction to MySQL Programming
APIs Available for MySQL
Choosing an API
The MySQL C API
General Procedure for Building Client Programs
Client 1—Connecting to the Server
Client 2—Adding Error Checking
Client 3—Making the Connection Code Modular
Client 4—Getting Connection Parameters at Runtime
Processing Queries
Client 5—An Interactive Query Program
Miscellaneous Topics
The Perl DBI API
Perl Script Characteristics
Perl DBI Basics
Putting DBI To Work
Using DBI in Web Applications
The PHP API
PHP Script Characteristics
PHP Basics
Putting PHP to Work
MySQL Administration
Introduction to MySQL Administration
Overview of Administrative Duties
General Administration
Security
Database Repair and Maintenance
The MySQL Data Directory
Location of the Data Directory
Structure of the Data Directory
Relocating Data Directory Contents
General MySQL Administration
Securing a New MySQL Installation
Arranging for MySQL Server Startup and Shutdown
Managing User Accounts
Maintaining Log Files
Backing Up and Copying Databases
Using Backups for Data Recovery
Tuning the Server
Running Multiple Servers
Updating MySQL
Security
Internal Security: Securing Data Directory Access
External Security: Securing Network Access
Database Maintenance and Repair
Checking and Repairing Database Tables
Scheduling Preventive Maintenance
Appendixes
Obtaining and Installing Software
Choosing What to Install
Obtaining the Software
Installing MySQL on UNIX
Installing MySQL on Windows
Obtaining and Installing the samp_db Sample Database Distribution
Column Type Reference
Numeric Types
String Types
Date and Time Types
Operator and Function Reference
Operators
Functions
SQL Syntax Reference
SQL Statements
Comment Syntax
MySQL Program Reference
Specifying Program Options
isamchk and myisamchk
myisampack and pack_isam
mysql
mysql.server
mysqlaccess
mysqladmin
mysqlbug
mysqld
mysqldump
mysqlimport
mysqlshow
safe_mysqld
C API Reference
Compiling and Linking
C API Data Types
C API Functions
Perl DBI API Reference
Writing Scripts
DBI Methods
DBI Utility Functions
DBI Attributes
DBI Environment Variables
PHP API Reference
Writing PHP Scripts
Functions
Useful Third-Party Tools
Internet Service Providers
Getting Ready to Shop for an ISP
Assessing an ISP—General Considerations
Assessing an ISP—MySQL-Specific Considerations
Colophon
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Colophon
Index
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset