The Definitive Guide to MySQL 5, Third Edition is the latest revision to Michael Kofler's popular comprehensive book on the world's most popular open source database server. Updated to reflect the changes in MySQL version 5, the most significant update in the product's history, readers are exposed to MySQL's impressive array of new features including views, stored procedures, triggers, spatial data types, and more. Novice and intermediate users alike will benefit from extensive coverage of core MySQL features such as user administration, basic and advanced querying, and security.

Autorentext
Michael Kofler holds a Ph.D. in computer science from Graz Technical University in Austria. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.

Klappentext

• 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.

Zusammenfassung

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.

Inhalt
What Is MySQL?.- The Test Environment.- Introductory Example (An Opinion Poll with PHP).- Administrative Tools and User Interfaces.- mysql, mysqladmin, and mysqldump.- MySQL Administrator and MySQL Query Browser.- phpMyAdmin.- Microsoft Office, OpenOffice/StarOffice.- Fundamentals.- Database Design.- An Introduction to SQL.- SQL Recipes.- Access Administration and Security.- GIS Functions.- Stored Procedures and Triggers.- Administration and Server Configuration.- Programming.- PHP.- Perl.- Java (JDBC and Connector/J).- C.- Visual Basic 6/VBA.- Visual Basic .NET and C#.- Reference.- SQL Reference.- MySQL Tools and Options.- API Reference.