Beginning Databases with MySQL - Softcover

Stones, Richard; Matthew, Neil

 
9781861006929: Beginning Databases with MySQL

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

"synopsis" may belong to another edition of 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.

Synopsis

MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. Because it is open source, anyone can download MySQL and tailor it to their needs in accordance with the general public license (GPL). MySQL is noted mainly for its speed, reliability and flexibility.

"About this title" may belong to another edition of this title.