The Definitive Guide to MySQL 5, Third Edition

The Definitive Guide to MySQL 5, Third Edition

by Michael Kofler (Author)

# Paperback: 784 pages
# Publisher: Apress; 3 edition (September 23, 2005)
# Language: English
# ISBN-10: 1590595351
# ISBN-13: 978-1590595350

Book Description

“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

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.

Popularity: 10% [?]

Note: We do not host these ebook files. If you have any complaint of copyright, please comment or contact us. We'll remove the download link immediatly!

• The Benefits of AIX Data Replication in HACMP Clusters
• The State of Resilience and Optimization on IBM Power Systems: Research Findings Based on Surveys of IBM i and AIX Users
• An Introduction to IBM System i (iSeries) High Availability Solutions

We are pleased to offer you this exciting, new, and entirely free professional resource. Visit our Free Industry resource center today to browse our selection of 600+ complimentary Industry magazines, white papers, webinars, podcasts, and more.
Download Links:
Link1 , Link2
Depositfiles
Tools to Download Faster
TweetBucks, Linkbee

Related eBooks - Up | Down