Book Categories

Description of Beginning MySQL Databases

The Publisher writes:

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
PUBCOMMENTS: This book is designed for those new to databases who want to start with MySQL and will lead you through your very first database query, to the complex database commands needed to solve 'real world' problems. However, it's an advantage if you know the essentials of SQL programming and for specific chapters, familiarity with PHP, Perl, and Java will be useful.

About the Authors:

Richard Stones is currently employed as a Systems Architect by GEHE, who are the UK's largest pharmaceutical wholesaler and retailer, as well as the largest pharmaceutical wholesaler in both France and Germany, and active in many other European countries.

Neil Matthew: As the Head of Software and Principal Engineer at Camtec Electronics in the 1980s, Neil Matthew programmed in C and C++ for real-time embedded systems. Since then he has worked on software development techniques and quality assurance, both as a consultant in communications software development with Scientific Generics and as a Systems Architect specialist with GEHE UK. Linux and other Open Source software like MySQL have played an increasing role in the work that he has undertaken over the years, from file servers, through Internet gateways to forming the platform for a distributed radio communications system.

Table of Contents:

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

Title Information

ISBN:

9781861006929

Pages:

575 pages

Format:

Paperback

Product Code:

159175

Publisher:

Wrox Press

Published:

01/03/2002

Write a review of this book

Customer Reviews from Amazon