Managing and Using Mysql (2 SUB)


Managing and Using Mysql (2 SUB)

  • 提携先の海外書籍取次会社に在庫がございます。通常2週間で発送いたします。
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合、分割発送となる場合がございます。
    3. 美品のご指定は承りかねます。
  • 製本 Paperback:紙装版/ペーパーバック版/ページ数 425 p.
  • 言語 ENG,ENG
  • 商品コード 9780596002114
  • DDC分類 005.7585

Full Description

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair.In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

Table of Contents

Preface                                            ix
Part I. Introduction
MySQL 3 (10)
Relational Databases 3 (2)
The History of MySQL 5 (2)
MySQL Design 7 (1)
MySQL Features 8 (2)
MySQL Applications 10 (1)
What You Get 11 (2)
Installation 13 (10)
Preparation 13 (1)
Unix Installation 14 (6)
Windows Installation 20 (3)
SQL According to MySQL 23 (41)
SQL Basics 23 (4)
Database Creation 27 (1)
Table Management 27 (3)
MySQL Data Types 30 (4)
Indexing 34 (2)
Managing Data 36 (4)
Queries 40 (6)
SQL Operators 46 (6)
Advanced Features 52 (12)
Database Administration 64 (17)
Configuration 64 (3)
Server Startup and Shutdown 67 (3)
Logging 70 (3)
Backup 73 (2)
Recovery 75 (1)
Table Maintenance and Crash Recovery 76 (5)
Part II. MySQL Administration
Performance Tuning 81 (14)
An Approach to Performance Tuning 81 (1)
Application Tuning 82 (11)
Database Server Tuning 93 (1)
Operating System/Hardware Tuning 94 (1)
Security 95 (24)
Database Security 95 (16)
System Security 111(4)
Application Security 115(4)
Database Design 119(18)
Database Design Primer 119(3)
Normalization 122(8)
A Logical Data-Modeling Methodology 130(1)
Physical Database Design 131(6)
Part III. MySQL Programming
Database Applications 137(10)
Architecture 137(4)
Connections and Transactions 141(3)
Object/Relational Modeling 144(3)
Perl 147(36)
Introduction to DBI 147(9)
DBI and CGI 156(8)
A General Model for Maintainable Perl 164(19)
Python 183(10)
DB-API 183(4)
Proprietary Operations 187(1)
Applied DB-API 187(6)
PHP 193(32)
Introducing PHP 193(6)
Installing PHP 199(3)
Accessing the MySQL DBMS with PHP 202(12)
Securing User Data 214(1)
Managing Sessions 215(2)
Writing Data with PHP 217(3)
Using the HTML <form> Environment 220(3)
Where to Find Out More 223(2)
CAPI 225(11)
API Overview 225(5)
The CAPI in Practice 230(4)
Advanced Issues 234(2)
Java 236(18)
The JDBC API 236(11)
Simple Database Access 247(4)
Dynamic Database Access 251(2)
A Guest Book Servlet 253(1)
Extending MySQL 254(23)
User-Defined Functions 254(15)
Alternative Character Sets 269(8)
Part IV. MySQL Reference
SQL Syntax for MySQL 277(33)
Basic Syntax 277(3)
SQL Commands 280(30)
MySQL Data Types 310(12)
Numeric Data Types 312(3)
String Data Types 315(3)
Date Data Types 318(2)
Complex Data Types 320(2)
Operators and Functions 322(16)
Operators 322(2)
Functions 324(14)
MySQL PHP API Reference 338(25)
Data Types 338(1)
Functions 339(24)
C Reference 363(31)
Data types 363(3)
Functions 366(28)
The Python DB-API 394(9)
Module: MySQLdb 394(9)
Index 403