"MySQL in a Nutshell": New Quick Reference Leads to Faster, More Productive Queries

"The popularity of MySQL has grown immensely. Monty Widenius and the others at MySQL AB have built an excellent database system. As a result, it's becoming dominant in the market place," observes Russell J.T. Dyer, author of the new MySQL in a Nutshell ( O'Reilly, US $39.95 ). "From the efforts of a small company with about 175 employees scattered around the world, located on every continent but Antarctica, MySQL AB is averaging about 35,000 downloads of their software every day. It's estimated that there are over 4 million installations worldwide."

As Dyer points out in his book, administration of MySQL is fairly effortless, owing to a variety of utilities that are packaged with the database. Nevertheless, MySQL and the APIs used for interacting with it are so rich and complex that it's challenging to remember all the possible nuances. MySQL in a Nutshell provides the syntax with easily understood explanations and examples, presented in the classic, quick-reference format of O'Reilly's In a Nutshell series that makes retrieving information quick and simple.

"I wanted a book that I can grab when I can't remember syntax for an SQL statement or a function," says Dyer. "I wanted a reference source that will give me what I need and quickly." Writing for MySQL administrators and developers of all skill levels, Dyer states that the goal of his book is to help readers quickly and easily understand how to get MySQL to do what they want or need it to do.

After introductory information on installing and formatting queries to MySQL, the book presents a reference listing of MySQL's features. Contents include:



SQL statements, with the clauses of the more complicated statements broken into groups of related functionality for easier reading
Functions provided by MySQL
Arguments and configuration options for the mysqld server
Arguments for the terminal client and a number of MySQL-related utilities, both within and outside the core distribution
API functions for Perl, PHP, and C

MySQL in a Nutshell offers a wealth of examples based on realistic applications that show how features will benefit users and make for simpler, faster, more productive queries. "It really is a required reference book for all members of the MySQL community," notes Dyer. "They will be able to find the syntax and usage of MySQL statements and functions, along with clear explanations for each and examples for almost all of them." The information in the book can make every MySQL user more productive--novice and veteran alike.

MySQL in a Nutshell
Russell J.T. Dyer
ISBN: 0-596-00789-2, 321 pages, $39.95 US, $55.95 CA
order@oreilly.com
1-800-998-9938; 1-707-827-7000

About O'Reilly
O'Reilly Media is the premier information source for leading-edge computer technologies. The company's books, conferences, and web sites bring to light the knowledge of technology innovators. O'Reilly books, known for the animals on their covers, occupy a treasured place on the shelves of the developers building the next generation of software. O'Reilly conferences and summits bring alpha geeks and forward-thinking business leaders together to shape the revolutionary ideas that spark new industries. From the Internet to XML, open source, .NET, Java, and web services, O'Reilly puts technologies on the map.

Related Articles

• MySQL CEO Marten Mickos to Present Next Wave of Affordable Database Adoption at the MySQL Users Conference
  Wednesday, 20 April 2005



• Embarcadero Technologies Offers Most Comprehensive Data Lifecycle Management Solution for MySQL Network
  Tuesday, 19 April 2005



• 2004-2005 MySQL Partner Awards
  Wednesday, 30 March 2005



• MySQL Manager 3 Immediately Available
  Friday, 18 March 2005



• Dot Hill Systems Corp. and MySQL AB Join Multivendor Support Alliance
  Thursday, 3 March 2005



• MySQL Appoints Mark Burton Executive Vice President of Worldwide Sales
  Sunday, 30 January 2005



• Beginning PHP 5 and MySQL E-Commerce- New Book from Apress
  Monday, 27 December 2004



• MySQL Lures Open-Source Newbies with Consulting Deals
  Friday, 17 December 2004



• Update on Omnis MySQL Crash
  Sunday, 12 December 2004



• MySQL Gets Graphic With DB Toolset
  Sunday, 12 December 2004



• MySQL Documentation and Books Available in OSofts ThoutReader-TM
  Thursday, 9 December 2004



• MySQL Server Crash Brings Down Omnis
  Wednesday, 8 December 2004