Beginning Databases with MySQL - Softcover

Stones, Richard; Matthew, Neil

Softcover

ISBN 10: 1861006926 ISBN 13: 9781861006929

Publisher: Apress, 2002

Synopsis

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

About this title

From the Publisher

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 Author

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.

Edition details

• Publisher: Apress
• Publication date: 2002
• ISBN 10: 1861006926
• ISBN 13: 9781861006929
• Binding: Paperback
• Language: English
• Number of pages: 550