View Larger Image	Michael Kofler Apress, Paperback, 3rd edition, Published September 2005, 784 pages, ISBN 1590595351
	List Price: $49.99 Our Price: $30.50 You Save: $19.49 (39% Off)
	Availability: In-Stock

People who purchase this book frequently purchase:

• MySQL in a Nutshell, 2nd Edition; Russell J.T. Dyer, $21.95, 37% Off!
• MySQL Cookbook, 2nd Edition; Paul DuBois, $31.50, 37% Off!
• Perl by Example, 4th Edition; Ellie Quigley, $27.25, 45% Off!
• Pro MySQL; Michael Kruckenberg, et al, $27.25, 45% Off!

• Databases : MySQL
• Other Topics : Open Source

• Apress

"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 product's history. The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Kofler's 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.

Table of Contents

About the Author xxiii
About the Translator xxv
Preface xxvii
PART 1 Introduction
Chapter 1 What Is MySQL? 3
Chapter 2 The Test Environment 17
Chapter 3 Introductory Example (An Opinion Poll with PHP) 47
PART 2 Administrative Tools and
User Interfaces
Chapter 4 mysql, mysqladmin, and mysqldump 61
Chapter 5 MySQL Administrator and MySQL Query Browser 71
Chapter 6 phpMyAdmin 87
Chapter 7 Microsoft Office, OpenOffice/StarOffice 117
PART 3 Fundamentals
Chapter 8 Database Design 137
Chapter 9 An Introduction to SQL 189
Chapter 10 SQL Recipes 217
Chapter 11 Access Administration and Security 263
Chapter 12 GIS Functions 299
Chapter 13 Stored Procedures and Triggers 317
Chapter 14 Administration and Server Configuration 345
PART 4 Programming
Chapter 15 PHP 403
Chapter 16 Perl 481
Chapter 17 Java (JDBC and Connector/J) 507
Chapter 18 C 527
Chapter 19 Visual Basic 6/VBA 545
Chapter 20 Visual Basic .NET and C# 573
PART 5 Reference
Chapter 21 SQL Reference 599
Chapter 22 MySQL Tools and Options 667
Chapter 23 API Reference 693
PART 6 Appendixes
Appendix A Glossary 723
Appendix B The Files for this Book 729
Appendix C Bibliography 731
Index 733

About the Author

Michael Kofler holds a Ph.D. in computer science from Graz Technical University. 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.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account