The Definitive Guide to MySQL 5, Third Edition (Definitive Guide)

for Those With A Need To Know, And Those With A Desire To Learn Mysql, This Volume Contains Nearly Everything You Would Want And Expect, Not Only About Mysql Itself But About The Software That Interacts With It Or Web Servers. — John Suda, Slashdot Contributor i've Seen The 2nd Edition (of) This Book And It's Good Stuff. — Arjen Lentz, Mysql Community Journal 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 Worlds Most Popular Open Source Database Server. Updated To Reflect Changes In Mysql Version 5, This Book Will Expose You To Mysqls Impressive Array Of New Features: Views, Stored Procedures, Triggers, And Spatial Data Types. whether Youre 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. The Definitive Guide to MySQL 5 1 Table of Content 6 PART 1 Introduction 34 Chapter 1 What Is MySQL? 36 Chapter 2 The Test Environment 50 Chapter 3 Introductory Example (An Opinion Poll with PHP) 80 PART 2 Administrative Tools and User Interfaces 92 Chapter 4 mysql, mysqladmin, and mysqldump 94 Chapter 5 MySQL Administrator and MySQL Query Browser. 104 Chapter 6 phpMyAdmin 120 Chapter 7 Microsoft Office, OpenOffice/StarOffice 150 PART 3 Fundamentals 168 Chapter 8 Database Design. 170 Chapter 9 An Introduction to SQL 222 Chapter 10 SQL Recipes 250 Chapter 11 Access Administration and Security 296 Chapter 12 GIS Functions. 332 Chapter 13 Stored Procedures and Triggers. 350 Chapter 14 Administration and Server Configuration 378 PART 4 Programming 434 Chapter 15 PHP 436 Chapter 16 Perl 514 Chapter 17 Java (JDBC and Connector/J) 540 Chapter 18 C 560 Chapter 19 Visual Basic 6/VBA 578 Chapter 20 Visual Basic .NET and C# 606 PART 5 Reference 630 Chapter 21 SQL Reference. 632 Chapter 22 MySQL Tools and Options 700 Chapter 23 API Reference 726 PART 6 Appendixes 754 Appendix A Glossary 756 Appendix B The Files for this Book 762 Appendix C Bibliography 764 Index 766 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. * MySQL 5, due to be released in summer 2005, is slated to be the most significant release in the product's history. The Definitive Guide to MySQL 5, Third Edition is the first book to offer in-depth instruction on the new features. * This book shows readers how to connect to MySQL via all of the major APIs, including PHP, Perl, Java, JSP, and C#/. * Novice and intermediate database administrators are introduced to both MySQL's key features, and crucial database management concepts by way of real-world examples such as discussion forums, online polls, and other data administration projects.