---

Managing and Using MySQL (2nd Edition)

ISBN: 0596002114
EAN: 2147483647

Year: 2002
Pages: 137

Authors: Tim King, George Reese, Randy Yarger, Hugh E. Williams, Randy Jay Yarger

BUY ON AMAZON

• Starting Page
• Table of Content
• Front Matter
• Preface
• Audience
• Purpose
• Using This Book
• Conventions Used in This Book
• Comments and Questions
• Acknowledgments
• Part I: Introduction
• Chapter 1. MySQL
• 1.1 Relational Databases
• 1.2 The History of MySQL
• 1.3 MySQL Design
• 1.4 MySQL Features
• 1.5 MySQL Applications
• 1.6 What You Get
• Chapter 2. Installation
• 2.1 Preparation
• 2.2 Unix Installation
• 2.3 Windows Installation
• Chapter 3. SQL According to MySQL
• 3.1 SQL Basics
• 3.2 Database Creation
• 3.3 Table Management
• 3.4 MySQL Data Types
• 3.5 Indexing
• 3.6 Managing Data
• 3.7 Queries
• 3.8 SQL Operators
• 3.9 Advanced Features
• Chapter 4. Database Administration
• 4.1 Configuration
• 4.2 Server Startup and Shutdown
• 4.3 Logging
• 4.4 Backup
• 4.5 Recovery
• 4.6 Table Maintenance and Crash Recovery
• Part II: MySQL Administration
• Chapter 5. Performance Tuning
• 5.1 An Approach to Performance Tuning
• 5.2 Application Tuning
• 5.3 Database Server Tuning
• 5.4 Operating SystemHardware Tuning
• Chapter 6. Security
• 6.1 Database Security
• 6.2 System Security
• 6.3 Application Security
• Chapter 7. Database Design
• 7.1 Database Design Primer
• 7.2 Normalization
• 7.3 A Logical Data-Modeling Methodology
• 7.4 Physical Database Design
• Part III: MySQL Programming
• Chapter 8. Database Applications
• 8.1 Architecture
• 8.2 Connections and Transactions
• 8.3 ObjectRelational Modeling
• Chapter 9. Perl
• 9.1 Introduction to DBI
• 9.2 DBI and CGI
• 9.3 A General Model for Maintainable Perl Programs
• Chapter 10. Python
• 10.1 DB-API
• 10.2 Proprietary Operations
• 10.3 Applied DB-API
• Chapter 11. PHP
• 11.1 Introducing PHP
• 11.2 Installing PHP
• 11.3 Accessing the MySQL DBMS with PHP
• 11.4 Securing User Data
• 11.5 Managing Sessions
• 11.6 Writing Data with PHP
• 11.7 Using the HTML form Environment
• 11.8 Where to Find Out More
• Chapter 12. C API
• 12.1 API Overview
• 12.2 The C API in Practice
• 12.3 Advanced Issues
• Chapter 13. Java
• 13.1 The JDBC API
• 13.2 Simple Database Access
• 13.3 Dynamic Database Access
• 13.4 A Guest Book Servlet
• Chapter 14. Extending MySQL
• 14.1 User-Defined Functions
• 14.2 Alternative Character Sets
• Part IV: MySQL Reference
• Chapter 15. SQL Syntax for MySQL
• 15.1 Basic Syntax
• 15.2 SQL Commands
• Chapter 16. MySQL Data Types
• 16.1 Numeric Data Types
• 16.2 String Data Types
• 16.3 Date Data Types
• 16.4 Complex Data Types
• Chapter 17. Operators and Functions
• 17.1 Operators
• 17.2 Functions
• Chapter 18. MySQL PHP API Reference
• 18.1 Data Types
• 18.2 Functions
• Chapter 19. C Reference
• 19.1 Data Types
• 19.2 Functions
• Chapter 20. The Python DB-API
• 20.1 Module: MySQLdb
• Colophon
• Index
• Index ASYMBOL
• 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 X
• Index Y