Table of content

•	Table of Contents
•	Index

MySQL, Second Edition
By Paul DuBois
Publisher	: Sams
Pub Date	: January 17, 2003
ISBN	: 0-7357-1212-3
Pages	: 1248
	Copyright
		About the Author
		About the Technical Reviewers
		Acknowledgments
			First Edition
			Second Edition
		Tell Us What You Think
		Introduction
			Why Choose MySQL?
			Already Running Another RDBMS?
			Tools Provided with MySQL
			What You Can Expect from This Book
			Road Map to This Book
			How to Read This Book
			Versions of Software Covered in This Book
			Conventions Used in This Book
			Additional Resources
		Part I:  General MySQL Use
			Chapter 1.  Getting Started with MySQL and SQL
				How MySQL Can Help You
				A Sample Database
				Basic Database Terminology
				A MySQL Tutorial
				Tips for Interacting with mysql
				Where to Now?
			Chapter 2.  Working with Data in MySQL
				MySQL Data Types
				MySQL Column Types
				Working with Sequences
				Character Set Support
				Choosing Column Types
				Expression Evaluation and Type Conversion
			Chapter 3.  MySQL SQL Syntax and Use
				MySQL Naming Rules
				Selecting, Creating, Dropping, and Altering Databases
				Creating, Dropping, Indexing, and Altering Tables
				Getting Information about Databases and Tables
				Retrieving Records from Multiple Tables
				Multiple-Table Deletes and Updates
				Performing Transactions
				Foreign Keys and Referential Integrity
				Using FULLTEXT Searches
				Writing Comments
				Features That MySQL Does Not Support
			Chapter 4.  Query Optimization
				Using Indexing
				The MySQL Query Optimizer
				Column Type Choices and Query Efficiency
				Loading Data Efficiently
				Scheduling and Locking Issues
				Optimization for Administrators
		Part II:  Using MySQL Programming Interfaces
			Chapter 5.  Introduction to MySQL Programming
				Why Write Your Own MySQL Programs?
				APIs Available for MySQL
				Choosing an API
			Chapter 6.  The MySQL C API
				General Procedure for Building Client Programs
				Client 1 Connecting to the Server
				Client 2 Adding Error Checking
				Client 3 Getting Connection Parameters at Runtime
				Processing Queries
				Client 4 An Interactive Query Program
				Writing Clients That Include SSL Support
				Using the Embedded Server Library
				Miscellaneous Topics
			Chapter 7.  The Perl DBI API
				Perl Script Characteristics
				Perl DBI Overview
				Putting DBI to Work
				Using DBI in Web Applications
			Chapter 8.  The PHP API
				PHP Overview
				Putting PHP to Work
		Part III:  MySQL Administration
			Chapter 9.  Introduction to MySQL Administration
				Overview of Administrative Duties
				General Administration
				Security
				Database Repair and Maintenance
			Chapter 10.  The MySQL Data Directory
				Location of the Data Directory
				Structure of the Data Directory
				Relocating Data Directory Contents
			Chapter 11.  General MySQL Administration
				Securing a New MySQL Installation
				Arranging for MySQL Server Startup and Shutdown
				Managing MySQL User Accounts
				Maintaining Log Files
				Additional Server Configuration Topics
				Running Multiple Servers
				Setting Up Replication Servers
				Updating MySQL
			Chapter 12.  Security
				Internal Security: Preventing Unauthorized File System Access
				External Security: Preventing Unauthorized Network Access
				Setting Up Secure Connections
			Chapter 13.  Database Backups, Maintenance, and Repair
				Coordinating with the Server
				Preparing for Disaster
				Table Repair and Data Recovery
		Part IV:  Appendixes
			Appendix A.  Obtaining and Installing Software
				Obtaining the sampdb Sample Database Distribution
				Obtaining MySQL and Related Software
				Installing MySQL on UNIX
				Installing MySQL on Windows
			Appendix B.  Column Type Reference
				Numeric Types
				String Types
				Date and Time Types
			Appendix C.  Operator and Function Reference
				Operators
				Functions
			Appendix D.  SQL Syntax Reference
				SQL Statements
				SQL Variables
				Comment Syntax
			Appendix E.  MySQL Program Reference
				Specifying Program Options
				libmysqld
				myisamchk and isamchk
				myisampack and pack_isam
				mysql
				mysqlaccess
				mysqladmin
				mysqlbinlog
				mysqlbug
				mysqlcheck
				mysql_config
				mysqld
				mysqld_multi
				mysqld_safe
				mysqldump
				mysqlhotcopy
				mysqlimport
				mysql_install_db
				mysql.server
				mysqlshow
				safe_mysqld
			Appendix F.  C API Reference
				Compiling and Linking
				C API Data Types
				C API Functions
			Appendix G.  Perl DBI API Reference
				Writing Scripts
				DBI Methods
				DBI Utility Functions
				DBI Attributes
				DBI Environment Variables
			Appendix H.  PHP API Reference
				Writing PHP Scripts
				Functions
			Appendix I.  Internet Service Providers
				Getting Ready to Shop for an ISP
				Assessing an ISP General Considerations
				Assessing an ISP MySQL-Specific Considerations
		Index