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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 15 Ratings

Great Introduction and Reference for MySQL - 2006-06-30
Reviewer Rating:
Learning MYSQL can be a little daunting for beginners because its open-source and you have to do some research in getting the right information sometimes. This book is aimed at the beginner who wants to get their feet wet with MYSQL and also how to use it with many of the more popular development platforms such as Java, Perl and PHP.

It is easy to read through because of its column-based format with enough snapshots and visual guides to prevent you from getting eye strain. -º

It first focuses on getting up and running on MySQL with the installation process on Windows or Mac or Linux (and UNIX). The book gives you all the links to install all the components of the database plus additional tools that will streamline you development process. There is also good information on how to upgrade your version of MySQL

The next chapter explains how to get you up and running in MySQL in the three different OS-¡+¥s with specifics on: Using mysqladmin, setting root password, using mysql client, setting up user privledges (creating new users) and starting and stopping services. A kinda detailed brief overview of how to be a MySQL admin.

Chapter 3 focuses on database design which usually can be kinda boring talking about normalization, importance of keys, table relationships, etc but the book only gives you the information you need with nice visuals to reinforce what is tauaght.

Chapter 4 goes over the MySQL and SQL commands in creating a database and table(s) with emphasis on field data types. Chapter 5 is a very useful chapter on basic SQL commands, since what is a database without the user knowing SQL, right? The author very succinctly reviews the SELECT statement for retrieving data, the UPDATE statement for updating records, DELETE and INSERT (you can guess what those two do). The book also goes into detail about table JOINS and filtering data with the WHERE, LIKE and GROUP BYclauses. A great resource chapter for the times you forget your basic syntax (which most people do from time to time).

Chapter 6 through 9 reviews how each of the more popular server-side web languages (PHP, Perl, and Java) use MyQL is used to retrieve, populate and update via web pages. The book provides code examples of the MySQL functions are specific to each language. Starting from how to connect to the database; how to execute commands; how to retrieve and display data (looping through records); how to incorporate error handling and how to secure your data. Depending on your preference, you will at least one of these chapters very helpful.

The next chapter focuses on new features in MySQL version 5 (stored procedures, triggers and views). These are somewhat advanced topics to a point but are covered wonderfully that even the newbie can understand.

The book finishes up with database administration issues such as performing and scheduling backups, logging, importing/exporting and repairing corruption issues.

A great introduction to MySQL that really can be your all-in-one reference as well.

A good starting point for beginners to mysql - 2005-10-24
Reviewer Rating:
The book is a bit out of date since it's assuming mysql version 3 is current and currently mysql v5 is what is currently released, but it has good instructions on installing mysql on multiple platforms as well as managing on multiple platforms

Superb introduction to MySQL - 2008-03-07
Reviewer Rating:
Larry Ullman has seemingly made a career out of his expertise in PHP and MySQL. And his expertise in both is unquestionable. Fortunately for those of us who wish to quickly grasp the essentials of these two technologies, Ullman is also an excellent teacher and writer.

MySQL walks you gently through the beginner to early intermediate level of familiarity with the platform.

It does not treat any aspect of MySQL in great depth - which is a plus, not a minus. Cruising this book will not make you an expert on MySQL, but it will place you firmly in control of the fundamentals so you can more comfortably continue on the path to becoming a MySQL. Think of it as "training wheels".

Overall, a thorough, painless introduction to MySQL for the rank beginner.

Jerry

Excellent Book - 2007-05-28
Reviewer Rating:
This book is excellent for someone with no experience with MySQL. (Like Me!) It steps you through installation, setup, and use without assuming prior knowledge.

great reference - 2008-12-11
Reviewer Rating:
I found this book a great MYSQL reference for me as PHP developer , Iam not a databse administrator , and i want to know more about mysql to help me better understand it and better code my PHP/Mysql projects , the book illustrate everything with figures and step by step from installation on various operating systems , runing Mysql and interacting with it through mysql client , database design and normalization , basic SQL , MySQL functions then illustrate MySQL/PHP interface in chapter 7 and MySQL/Perl chapter 8 and MySQL/JAVA chapter 9 , then Advanced SQL and MySQL manipulation in chapter 10 which cover transactions , full text searches , regular expressions , user defined variables and Unions , then cover the new features in MySQL 5 like Stored routines , using OUT parameters , Triggers and views , then in chapter 12 Illustrate some techniques for progamming best practice , and end with chapter 13 MySQL administration . After all this book is very good and wrap my mind around topics i never heard about in normal PHP books that only cover mysql in one chapter for PHP/Mysql interface .

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > MySQL