MySQL

MySQL

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1 MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited fo...

Descripción completa

Detalles Bibliográficos
Autor principal: DuBois, Paul, 1956- (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Upper Saddle River, NJ : Addison-Wesley c2009.
Edición:4th ed
Colección:Developer's library
Materias:
MySQL (Electronic resource)
SQL (Computer program language)
Database management.
Database management
Engineering & Applied Sciences
Computer Science
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627623306719
Tabla de Contenidos:
  • Cover
  • Table of Contents
  • Introduction
  • Why Choose MySQL?
  • Already Running Another RDBMS?
  • Tools Provided with MySQL
  • What You Can Expect from This Book
  • Road Map to This Book
  • Part I: General MySQL Use
  • Part II: Using MySQL Programming Interfaces
  • Part III: MySQL Administration
  • Part IV: Appendixes
  • How to Read This Book
  • Versions of Software Covered in This Book
  • Conventions Used in This Book
  • Additional Resources
  • I: General MySQL Use
  • 1 Getting Started with MySQL
  • 1.1 How MySQL Can Help You
  • 1.2 A Sample Database
  • 1.3 Basic Database Terminology
  • 1.4 A MySQL Tutorial
  • 1.5 Tips for Interacting with mysql
  • 1.6 Where to Now?
  • 2 Using SQL to Manage Data
  • 2.1 The Server SQL Mode
  • 2.2 MySQL Identifier Syntax and Naming Rules
  • 2.3 Case Sensitivity in SQL Statements
  • 2.4 Character Set Support
  • 2.5 Selecting, Creating, Dropping, and Altering Databases
  • 2.6 Creating, Dropping, Indexing, and Altering Tables
  • 2.7 Obtaining Database Metadata
  • 2.8 Performing Multiple-Table Retrievals with Joins
  • 2.9 Performing Multiple-Table Retrievals with Subqueries
  • 2.10 Performing Multiple-Table Retrievals with UNION
  • 2.11 Using Views
  • 2.12 Multiple-Table Deletes and Updates
  • 2.13 Performing Transactions
  • 2.14 Foreign Keys and Referential Integrity
  • 2.15 Using FULLTEXT Searches
  • 3 Data Types
  • 3.1 Data Value Categories
  • 3.2 MySQL Data Types
  • 3.3 How MySQL Handles Invalid Data Values
  • 3.4 Working with Sequences
  • 3.5 Expression Evaluation and Type Conversion
  • 3.6 Choosing Data Types
  • 4 Stored Programs
  • 4.1 Compound Statements and Statement Delimiters
  • 4.2 Stored Functions and Procedures
  • 4.3 Triggers
  • 4.4 Events
  • 4.5 Security for Stored Programs and Views
  • 5 Query Optimization
  • 5.1 Using Indexing
  • 5.2 The MySQL Query Optimizer.
  • 5.3 Choosing Data Types for Efficient Queries
  • 5.4 Loading Data Efficiently
  • 5.5 Scheduling and Locking Issues
  • 5.6 Administrative-Level Optimizations
  • II: Using MySQL Programming Interfaces
  • 6 Introduction to MySQL Programming
  • 6.1 Why Write Your Own MySQL Programs?
  • 6.2 APIs Available for MySQL
  • 6.3 Choosing an API
  • 7 Writing MySQL Programs Using C
  • 7.1 Compiling and Linking Client Programs
  • 7.2 Connecting to the Server
  • 7.3 Handling Errors and Processing Command Options
  • 7.4 Processing SQL Statements
  • 7.5 An Interactive Statement-Execution Program
  • 7.6 Writing Clients That Include SSL Support
  • 7.7 Using the Embedded Server Library
  • 7.8 Using Multiple-Statement Execution
  • 7.9 Using Server-Side Prepared Statements
  • 8 Writing MySQL Programs Using Perl DBI
  • 8.1 Perl Script Characteristics
  • 8.2 Perl DBI Overview
  • 8.3 Putting DBI to Work
  • 8.4 Using DBI in Web Applications
  • 9 Writing MySQL Programs Using PHP
  • 9.1 PHP Overview
  • 9.2 Putting PHP to Work
  • III: MySQL Administration
  • 10 Introduction to MySQL Administration
  • 10.1 MySQL Components
  • 10.2 General MySQL Administration
  • 10.3 Access Control and Security
  • 10.4 Database Maintenance, Backups, and Replication
  • 11 The MySQL Data Directory
  • 11.1 Location of the Data Directory
  • 11.2 Structure of the Data Directory
  • 11.3 Relocating Data Directory Contents
  • 12 General MySQL Administration
  • 12.1 Securing a New MySQL Installation
  • 12.2 Arranging for MySQL Server Startup and Shutdown
  • 12.3 Controlling How the Server Listens for Connections
  • 12.4 Managing MySQL User Accounts
  • 12.5 Maintaining Logs
  • 12.6 Tuning the Server
  • 12.7 Storage Engine Configuration
  • 12.8 Enabling or Disabling LOCAL Capability for LOAD DATA
  • 12.9 Internationalization and Localization Issues
  • 12.10 Running Multiple Servers
  • 12.11 Updating MySQL.
  • 13 Access Control and Security
  • 13.1 Internal Security: Preventing Unauthorized Filesystem Access
  • 13.2 External Security: Preventing Unauthorized Network Access
  • 13.3 Setting Up Secure Connections
  • 14 Database Maintenance, Backups, and Replication
  • 14.1 Principles of Preventive Maintenance
  • 14.2 Performing Database Maintenance with the Server Running
  • 14.3 General Preventative Maintenance
  • 14.4 Making Database Backups
  • 14.5 Copying Databases to Another Server
  • 14.6 Checking and Repairing Database Tables
  • 14.7 Using Backups for Data Recovery
  • 14.8 Setting Up Replication Servers
  • IV: Appendixes
  • A: Obtaining and Installing Software
  • A.1 Obtaining the sampdb Sample Database Distribution
  • A.2 Obtaining MySQL and Related Software
  • A.3 Choosing a Version of MySQL
  • A.4 Installing MySQL on Unix
  • A.5 Installing MySQL on Windows
  • B: Data Type Reference
  • B.1 Numeric Types
  • B.2 String Types
  • B.3 Date and Time Types
  • B.4 Spatial Types
  • C: Operator and Function Reference
  • C.1 Operators
  • C.2 Functions
  • D: System, Status, and User Variable Reference
  • D.1 System Variables
  • D.2 Session-Only System Variables
  • D.3 Status Variables
  • D.4 User-Defined Variables
  • E: SQL Syntax Reference
  • E.1 SQL Statement Syntax (Non-Compound Statements)
  • E.2 Compound Statement Syntax
  • E.3 Comment Syntax
  • F: MySQL Program Reference
  • F.1 Displaying a Program's Help Message
  • F.2 Specifying Program Options
  • F.3 myisamchk
  • F.4 myisampack
  • F.5 mysql
  • F.6 mysql.server
  • F.7 mysql_config
  • F.8 mysql_install_db
  • F.9 mysqladmin
  • F.10 mysqlbinlog
  • F.11 mysqlcheck
  • F.12 mysqld
  • F.13 mysqld_multi
  • F.14 mysqld_safe
  • F.15 mysqldump
  • F.16 mysqlhotcopy
  • F.17 mysqlimport
  • F.18 mysqlshow
  • F.19 perror
  • G: C API Reference
  • G.1 Compiling and Linking
  • G.2 C API Data Types
  • G.3 C API Functions.
  • H: Perl DBI API Reference
  • H.1 Writing Scripts
  • H.2 DBI Methods
  • H.3 DBI Utility Functions
  • H.4 DBI Attributes
  • H.5 DBI Environment Variables
  • I: PHP API Reference
  • I.1 Writing PHP Scripts
  • I.2 PDO Classes
  • I.3 PDO Methods
  • Index.

Ejemplares similares