Sebastopol, CA--Stable and reliable, MySQL may not possess the elan of trendier open source technologies, but it has definitely earned its standing as one of the true success stories of the open source movement. Long a favorite database in the Linux and open source communities, it's made significant inroads into areas that used to be the exclusive province of Oracle or MS SQL Server. While its price is attractive--the GPL-licensed version is free for internal use, and commercial licenses and support are quite inexpensive--affordability is not the only factor in MySQL's success. There are, after all, other cost-free, open source databases available, but few can compete with MySQL's solid reputation for speed, ease of use, and flexibility.
"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
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.
- Chapter 6, "Date and Time Functions"
- More information about the book, including table of contents, index, author bio, and samples
- A cover graphic in JPEG format
O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O’Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying “faint signals” from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.