Managing & using MySQL
George Reese, Randy Jay Yarger, Tim King, Hugh E. Williams
Résumé
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
Part I. Introduction
1. MySQL
Relational Databases
The History of MySQL
MySQL Design
MySQL Features
MySQL Applications
What You Get
2. Installation
Preparation
Unix Installation
Windows Installation
3. SQL According to MySQL
SQL Basics
Database Creation
Table Management
MySQL Data Types
Indexing
Managing Data
Queries
SQL Operators
Advanced Features
4. Database Administration
Configuration
Server Startup and Shutdown
Logging
Backup
Recovery
Table Maintenance and Crash
Recovery
Part II. MySQL Administration
5. Performance Tuning
An Approach to Performance
Tuning
Application Tuning
Database Server Tuning
Operating System/Hardware Tuning
6. Security
Database Security
System Security
Application Security
7. Database Design
Database Design Primer
Normalization
A Logical Data-Modeling
Methodology
Physical Database Design
Part III. MySQL Programming
8. Database Applications
Architecture
Connections and Transactions
Object/Relational Modeling
9. Perl
Introduction to DBI
DBI and CGI
A General Model for Maintainable Perl
Programs
10. Python
DB-API
Proprietary Operations
Applied DB-API
11. PHP
Introducing PHP
Installing PHP
Accessing the MySQL DBMS with
PHP
Securing User Data
Managing Sessions
Writing Data with PHP
Using the HTML <form>
Environment
Where to Find Out More
12. C API
API Overview
The C API in Practice
Advanced Issues
13. Java
The JDBC API
Simple Database Access
Dynamic Database Access
A Guest Book Servlet
14. Extending MySQL
User-Defined Functions
Alternative Character Sets
Part IV. MySQL Reference
15. SQL Syntax for MySQL
Basic Syntax
SQL Commands
16. MySQL Data Types
Numeric Data Types
String Data Types
Date Data Types
Complex Data Types
17. Operators and Functions
Operators
Functions
18. MySQL PHP API Reference
Data Types
Functions
19. C Reference
Data types
Functions
20. The Python DB-API
Module: MySQLdb
Index
L'auteur - George Reese
George Reese has taken an unusual path into business
software development. After
earning a B.A. in philosophy from Bates College in
Lewiston, Maine, George went off
to Hollywood where he worked on television shows such as
The People's Court and
ESPN's Up Close. The L.A. riots convinced him to return to
Maine where he finally
became involved with software development and the Internet.
George has since
specialized in the development of Internet-oriented Java
enterprise systems. He is the
author of Database Programming with JDBC and Java and the
world's first JDBC
driver, the mSQL-JDBC driver for mSQL. He currently lives
in Minneapolis,
Minnesota with his wife Monique and three cats, Misty,
Gypsy, and Tia. He makes
his living as a senior architect for Imaginet, LLC.
L'auteur - Hugh E. Williams
Hugh E. Williams is a software design engineer at Microsoft's Windows Live Search in Redmond, WA. Previously, he was the Associate Professor in Information Retrieval at RMIT University in Melbourne, Australia. He's published over 70 research papers and holds around 10 patents, mostly in the search engine area. When not at work Hugh likes to hang out with his family, exercise, watch Richmond play footy, and learn about baseball. Hugh has a PhD from RMIT University. His home page is http://hughwilliams.com.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | George Reese, Randy Jay Yarger, Tim King, Hugh E. Williams |
| Parution | 03/07/2002 |
| Édition | 2eme édition |
| Nb. de pages | 426 |
| Format | 17,7 x 23,4 |
| Couverture | Broché |
| Poids | 695g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780596002114 |
| ISBN13 | 978-0-596-00211-4 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
