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


MySQL
High Performance MySQL: Optimization, Backups, Replication, and More
ISBN: 0596101716
EAN: 2147483647
Year: 2003
Pages: 188

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net