MySQL, Second Edition: Visual QuickStart Guide (Visual QuickStart Guides)

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

MySQL has become a remarkably popular database application while, even more remarkably, maintaining its open-source roots. It can handle databases as large as 60,000 tables with more than five billion rows, but even those with more modest demands can find it very accommodating. Practitioner Ullman updates for MySQL 4 and 5 while covering installing and running MySQL, learning database design, creating a database, working through basics such as inserting and selecting data, using functions, working with PHP and Perl as well as Java, using advanced SQL such as full-text searching, building techniques for programming such as storing and retrieving binary data, and managing administration. He also includes information on troubleshooting, references and resources.
Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

MySQL has become a remarkably popular database application while, even more remarkably, maintaining its open-source roots. It can handle databases as large as 60,000 tables with more than five billion rows, but even those with more modest demands can find it very accommodating. Practitioner Ullman updates for MySQL 4 and 5 while covering installing and running MySQL, learning database design, creating a database, working through basics such as inserting and selecting data, using functions, working with PHP and Perl as well as Java, using advanced SQL such as full-text searching, building techniques for programming such as storing and retrieving binary data, and managing administration. He also includes information on troubleshooting, references and resources. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

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 invaluable reference. In clear, concise language, this volume demonstrates how to interact with MySQL--both directly and through various popular programming languages.

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.

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.