Core Mysql

Leon Atkinson

722 pages, parution le 05/03/2002

Ajouter à une liste

Indisponible

Résumé

The comprehensive, code-rich MySQL guide for expert developers.

Contains in-depth explanations and example code for designing and building enterprise-level systems
Includes advanced coverage of security, data storage, optimization, distributed databases, and other complex topics
Presented by leading open-source expert Leon Atkinson—author of the best-selling Core PHP Programming

Experienced developers worldwide are choosing MySQL as a low-cost, open-source foundation for their key Web applications. Now, here's a book that gives them all the code and insight they need to build enterprise-class MySQL applications—fast.

Core MySQL starts by introducing the fundamentals of MySQL: SQL queries, database design, normalization, transactions, and concurrency. It then systematically reviews each of MySQL's most important features, and presents efficient techniques for interacting with MySQL databases directly from C, Java, PHP, Perl, Python, and other programming environments.

Coverage includes:

Installing and interacting with MySQL—including a detailed introduction to MySQL's SQL implementation
Data types, variables, column types, built-in functions, and command-line utilities
Comprehensive coverage of using MySQL's C API
MySQL administration, backup, and disaster recovery
Application optimization and security
Distributed database development
Extending MySQL with added functionality
Building databases that can be transitioned to other database platforms

Thoroughly reviewed by MySQL lead develCore MySQL gives professionals exactly what they've been searching for: an authoritative, thorough, example-rich guide to enterprise-class MySQL application development.

Contents

Acknowledgments
Introduction

Pt. 1 MySQL and the Relational Model 1

1 Introduction to MySQL 3
2 Installing MySQ 19
3 Interacting with MySQL 27
4 Database Concepts 35
5 The Relational Model 47
6 Structured Query Language 63
7 Database Design 77
8 Normalization 95
9 Transactions and Concurrency 109

Pt. 2 MySQL Reference 119

10 Data Types, Variables, and Expressions 121
11 Column and Index Types 139
12 Built-in Functions 153
13 SQL Statements 213
14 Command-Line Utilities 283
15 C API 379

Pt. 3 Writing MySQL Clients 433

16 Programming the C API 435
17 JDBC 447
18 VBScript and ODBC 457
19 PHP 467
20 Perl 475
21 Python 483
22 MySQL++ API 489

Pt. 4 Advanced Topics 497

23 Database Administration 499
24 Physical Storage 507
25 Coping with Disaster 527
26 Optimization 539
27 Security 563
28 Transitioning 577
29 Distributed Databases 593
30 Object Mapping 609
31 Adding Functionality 627

App. A: Online Resources 643
App. B: Further Reading 649
App. C Business and Legal Concerns 651
App. D: Reserved Words 663
App. E MySQL Error Codes 667
App. F SQL Style Guide 683
App. G Example Database Design

Extrait du livre

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Leon Atkinson
Parution	05/03/2002
Nb. de pages	722
Format	18 x 23,5
Couverture	Broché
Poids	1090g
Intérieur	Noir et Blanc
EAN13	9780130661906