Synopses & Reviews
Even if you've never used MySQL before, this Visual QuickStart Guide
will have you up and running with the world’s most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology author Larry Ullman
uses his trademark crystal-clear instructions and friendly prose to introduce you to everything that’s new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQL’s own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you'll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more!
• Takes an easy, visual approach to teaching MySQL, using pictures to guide you through the software and show you what to do.
• Works like a reference book—you look up what you need and then get straight to work.
• No long-winded passages—concise, straightforward commentary explains what you need to know.
• Affordably priced, because buying a computer book shouldn’t be an investment in itself.
• Companion Web site at www.DMCInsights.com/mysql2 contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.
With the Web extending into every nook and cranny of modern life, there are plenty of folks out there who have data storage issues that need to be addressed but no million-dollar budgets to do so. Luckily for them, there's MySQL. Offering Oracle-like power without the huge price tag, MySQL offers a networked database that can be accessed in numerous ways-Qall of which are described in this invaluable reference. In the clear, concise language readers have come to expect from this popular series, this Visual QuickStart Guide demonstrates how to interact with MySQL both directly and through various popular programming languages (for example, PHP, Perl, and Java). Step-by-step instructions, practical examples, plenty of screen shots, and loads of useful tips and tricks make learning MySQL a breeze, even for novice programmers. Focusing first on the underlying concepts What are databases? What is MySQL? author Larry Ullman then proceeds through installation, administration, database design, and more before tackling MySQL's use with various programming languages, database programming techniques, and utilities. Web developers, system administrators, programmers, and just about anybody who uses databases will find themselves turning again and again to this essential guide.
Offering Oracle-like power without the huge price tag, MySQL offers a networked database that can be accessed in numerous ways - all of which are described in this comprehensive reference. In clear, concise language this guide demonstrates how to interact with MySQL.
About the Author
Larry Ullman is the Director of Digital Media Technology at DMC Insights, Inc., a firm specializing in information technology. He is the author of several books on PHP, MySQL, and Web development, including PHP for the World Wide Web: Visual QuickStart Guide (1st and 2nd editions). In addition to writing, he develops dynamic Web applications (in PHP and ASP.NET), conducts training seminars (on PHP, Oracle, and SQL), and teaches at the University of California Berkeley Extension Online.
Table of Contents
1. Installing MySQL.
2. Running MySQL.
3. Database Design.
5. MySQL Functions.
6. MySQL and PHP.
7. MySQL and Perl.
8. MySQL and Java.
9. Database Programming Techniques.
10. MySQL Administration.
11. Advanced MySQL.
Appendix A: Troubleshooting.
Appendix B: SQL and MySQL References.
Appendix C: Resources.