Beginning Databases with MySQL

Neil Matthew, Richard Stones

576 pages, parution le 04/04/2002

Ajouter à une liste

Indisponible

Résumé

MySQL is the world's most popular Open Source Relational Database designed for speed, power, and precision in heavy load use. MySQL AB is the company owned and run by the MySQL founders and main developers. MySQL offers the database programmer with a range of options and capabilities rarely seen in other database servers. MySQL runs under a broad array of operating systems.

This book is a complete tutorial on MySQL features and functions and takes you through the whole process from installation and configuration of MySQL to executing commands and basic administration of the database server. We'll show you how to integrate MySQL with programming languages for the Web.

What does this book cover?

Detailed tutorial in MySQL
Installing from binaries and source code on UNIX and Windows
Working with graphical tools
Various forms of queries, subqueries, aggregate functions, and joins
Discussion on transactions and locking
Performance monitoring, tuning, and server control
Connecting and executing SQL statements using C and C++
Developing applications in PHP, Perl, and Java using MySQL

Contents

Introduction

Chapter 1 : Introduction to MySQL
Chapter 2 : Relational Database Principles
Chapter 3 : Installing and Getting Started with MySQL
Chapter 4 : Accessing your Data
Chapter 5 : MySQL Graphical Tools
Chapter 6 : Changing your Data
Chapter 7 : Advance Data Selection
Chapter 8 : Data Definition and Manipulation
Chapter 9 : Transactions and Locking
Chapter 10 : MySQL Administration
Chapter 11 : Database Design
Chapter 12 : Accessing MySQL from C and C++
Chapter 13 : Accessing MySQL from PHP
Chapter 14 : Accessing MySQL from Perl
Chapter 15 : Accessing MySQL from Java
Chapter 16 : Further Information and Resources

Appendix A : MySQL Database Limits
Appendix B : MySQL Data types
Appendix C : MySQL SQL Syntax
Appendix D : mysql Reference
Appendix E : Database Schema and Tables
Appendix F : Large Objects Support in MySQL

Index

L'auteur - Neil Matthew

Neil Matthew - Neil Matthew graduated with a degree in mathematics from the University of Nottingham in the UK and has been using and programming computers for over 30 years. Neil has used just about every flavor of UNIX since 1978, right up to today's Linux distributions. He has co-authored several computing books with Richard Stones, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.

L'auteur - Richard Stones

Richard Stones - Richard Stones graduated from university with an electrical engineering degree, but decided software was more fun. He has programmed in a variety of languages, but only admits to knowing VB under duress. He has worked for a number of companies, from the very small to the very large, in a variety of areas, from real-time embedded systems upward. He is currently employed by Celesio AG as a systems architect, working principally on systems for the retail side of the business. He has co-authored several computing books with Neil Matthew, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Neil Matthew, Richard Stones
Parution	04/04/2002
Nb. de pages	576
Format	18,5 x 23
Couverture	Broché
Poids	962g
Intérieur	Noir et Blanc
EAN13	9781861006929