Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0 - page 1
Buy on amazon.com >>
DuBois P.
<< Previous book
Next page >>
1
2
3
MySQL The definitive guide to using, programming, and administering MySQL 4.1 and 5.0 Third Edition
MySQL The definitive guide to using, programming, and administering MySQL 4.1 and 5.0 Third Edition
Table of Contents
Copyright
About the Author
Acknowledgments
Third Edition
Second Edition
First 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
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. MySQL SQL Syntax and Use
MySQL Naming Rules
The Server SQL Mode
Character Set Support
Selecting, Creating, Dropping, and Altering Databases
Foreign Keys and Referential Integrity
Using FULLTEXT Searches
New Features in MySQL 5.0
Chapter 3. Working with Data in MySQL
Categories of Data Values
MySQL Data Types
How MySQL Handles Invalid Data Values
Working with Sequences
Choosing Data Types
Expression Evaluation and Type Conversion
Chapter 4. Query Optimization
Using Indexing
The MySQL Query Optimizer
Data Type Choices and Query Efficiency
Loading Data Efficiently
Scheduling and Locking Issues
Optimization for Administrators
Chapter 5. Introduction to MySQL Programming
Why Write Your Own MySQL Programs?
APIs Available for MySQL
Choosing an API
Chapter 6. Writing MySQL Programs Using C
General Instructions for Building Client Programs
Connecting to the Server
Handling Errors and Processing Command Options
Processing SQL Statements
An Interactive Statement-Execution Program
Writing Clients That Include SSL Support
Using the Embedded Server Library
Using Multiple-Statement Execution
Using Server-Side Prepared Statements
Chapter 7. Writing MySQL Programs Using Perl DBI
Perl Script Characteristics
Perl DBI Overview
Putting DBI to Work
Using DBI in Web Applications
Chapter 8. Writing MySQL Programs Using PHP
PHP Overview
Putting PHP to Work
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
1
2
3
Buy on amazon.com >>
DuBois P.
<< Previous book
Next page >>