MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, Third Edition is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the world's most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL's impressive array of new features: views, stored procedures, triggers, and spatial data types.
Whether you’re a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.
| Ch. 1 | What is MySQL? | 3 |
| Ch. 2 | The test environment | 17 |
| Ch. 3 | Introductory example (an opinion poll with PHP) | 47 |
| Ch. 4 | Mysqul, mysqladmin, and mysqldump | 61 |
| Ch. 5 | MySQL administrator and MySQL query browser | 71 |
| Ch. 6 | phpMyAdmin | 87 |
| Ch. 7 | Microsoft Office, OpenOffice/StarOffice | 117 |
| Ch. 8 | Database design | 137 |
| Ch. 9 | An introduction to SQL | 189 |
| Ch. 10 | SQL recipes | 217 |
| Ch. 11 | Access administration and security | 263 |
| Ch. 12 | GIS functions | 299 |
| Ch. 13 | Stored procedures and triggers | 317 |
| Ch. 14 | Administration and server configuration | 345 |
| Ch. 15 | PHP | 403 |
| Ch. 16 | Perl | 481 |
| Ch. 17 | Java (JDBC and Connector/J) | 507 |
| Ch. 18 | C | 527 |
| Ch. 19 | Visual Basic 6/VBA | 545 |
| Ch. 20 | Visual Basic .NET and C# | 573 |
| Ch. 21 | SQL reference | 599 |
| Ch. 22 | MySQL tools and options | 667 |
| Ch. 23 | API reference | 693 |
Overview
MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, Third Edition is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the world's most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL's impressive array of new features: views, stored procedures, triggers, and spatial ...