MySQL: Your visual blueprint for creating open source databases [Paperback]

Michael Moncur (Author)

Book Description

Series: Visual Read Less, Learn More | Publication Date: October 23, 2002

* Discusses the basic fundamentals including database terminology and concepts.
* Offers an introduction to MySQL and the SQL language, then includes essential tasks to begin using it.
* Explores the essentials of MySQL server management, providing a guide for troubleshooting problems.
* Presents numerous annotated screenshots, tips and tricks.
* Includes a CD-ROM with additional code examples as well as advanced examples using MySQL for UNIX and Windows, PHP for Windows and UNIX, and PHPMyAdmin for UNIX.

Editorial Reviews

Review

"...a fine introduction to MySQL and a lasting reference guide to boot..." (IT Training, February 2003)

From the Back Cover

MySQL, Perl, and PHP software on CD-ROM!

• Also includes Apache and phpMyAdmin, with usage examples for Windows and UNIX
• Plus a fully searchable e-version of the book, and more

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you’ll discover step-by-step screen shots that demonstrate over 500 MySQL tips, features, and characteristics, including:

• Managing databases and tables
• Modifying tables
• Using SELECT queries
• Adding, deleting, and updating data
• Applying MySQL functions
• Importing and exporting data
• Managing the MySQL server
• Optimizing and troubleshooting MySQL
• Configuring MySQL security
• Using MySQL with PHP and Perl

Software and examples on CD-ROM!

• Includes MySQL, Perl, and PHP software
• Includes Apache Web server, phpMyAdmin, and DBD:MySQL
• Code examples and advanced usage examples for both Windows and UNIX
• Plus a searchable e-version of the book

See all Editorial Reviews

Product Details

• Paperback: 352 pages
• Publisher: Visual (October 23, 2002)
• Language: English
• ISBN-10: 0764516922
• ISBN-13: 978-0764516924
• Product Dimensions: 8.9 x 8 x 0.8 inches
• Shipping Weight: 1.3 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #690,440 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars Great for quick starts, January 30, 2004

By A Customer

This review is from: MySQL: Your visual blueprint for creating open source databases (Paperback)

This book is great if you're looking to get started quickly with MySQL. I was able to set up and create a database within hours after buying the book, with only minimal prior exposure to MySQL. Plus, it's a great quick reference for some of the standard MySQL commands that you may not need to use on a super-regular basis. The majority of the teaching is done through diagrams and examples, which allows the user to see what's supposed to happen, and have a gauge of how their performing. The text is just over half of the meat of the book, and really just fills in the blank spots that the diagrams leave out. I highly recommend this book for anyone just getting started with MySQL, but it as you get more proficient, you might want to pass it on to another MySQL newbie, as it may just gather dust on your bookshelf.

3 of 3 people found the following review helpful:

4.0 out of 5 stars Good and easy Reading Intro Book., January 27, 2005

By 

Marcus Abundus (Los Altos, CA USA) - See all my reviews

This review is from: MySQL: Your visual blueprint for creating open source databases (Paperback)

This book is part of a series of Visual Blueprint (tm) books. the subtitle reads Your visual blueprint to oepn source database mangement. There are others in this series on PHP, XML, and Javascript that I know of.

The format is clear and obvious. Of course with the blue ink and the graphical layout, it is designed to resemble building plans or blueprints. The format is such that each ajoining pages tackle one command or subject. The subject is narrow in focus allowing you to concentrate on that one topic. Examples include topics such as Delete a Column, Understanding Date and Time Functions, View and manage running processes.

On each two-page topic they have included four screen views that are annotated with helpful hints as to what has happened on the screen. Also there is a text portion that analyzes the specific command. On the right page is a text box titled "Extra" that goes into more depth.

This rigid format makes the book easy to read and reference, but it also forces that authors to make a point in no more than several paragraphs sometimes limiting the topics effectivness.

So I liked this book in the way its consistant design and format makes it very easy to read and learn the topics one step at a time. Looking forward to reading the other books in the series.