| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Wed, 16 Jul 2025 07:18:06 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090420031957
location: https://web.archive.org/web/20090420031957/https://www.oreilly.com/catalog/9780596007898/
server-timing: captures_list;dur=0.612853, exclusion.robots;dur=0.018607, exclusion.robots.policy;dur=0.007233, esindex;dur=0.012105, cdx.remote;dur=19.271341, LoadShardBlock;dur=244.978101, PetaboxLoader3.datanode;dur=77.697391, PetaboxLoader3.resolve;dur=79.229730
x-app-server: wwwb-app239
x-ts: 302
x-tr: 305
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1
set-cookie: SERVER=wwwb-app239; path=/
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Wed, 16 Jul 2025 07:18:07 GMT
content-type: text/html
x-archive-orig-date: Mon, 20 Apr 2009 03:19:34 GMT
x-archive-orig-server: Apache
x-archive-orig-p3p: policyref="https://www.oreillynet.com/w3c/p3p.xml",CP="CAO DSP COR CURa ADMa DEVa TAIa PSAa PSDa IVAa IVDa CONo OUR DELa PUBi OTRa IND PHY ONL UNI PUR COM NAV INT DEM CNT STA PRE"
x-archive-orig-last-modified: Fri, 17 Apr 2009 02:27:09 GMT
x-archive-orig-accept-ranges: bytes
x-archive-orig-content-length: 40647
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: iso-8859-1
memento-datetime: Mon, 20 Apr 2009 03:19:57 GMT
link: ; rel="next memento"; datetime="Fri, 22 May 2009 04:56:28 GMT", MySQL in a Nutshell | O'Reilly Media
Featured customer reviews
USA Linux Users Group Book Review, June 09 2006
MySQL in a Nutshell is for those new to mysql and also useful for those that are experienced with this database. As with most of the Nutshell books, this book is more of a complete reference for commands. Not really designed to be read cover to cover, it does provide an excellent reference for anyone that deals with the popular mysql database. The excellent examples and detailed explanations for SQL statements and the many functions make this a must have book for those just starting out, and a handy reference for those that have been using mysql for years.
The first chapter is the obligatory introduction to mysql and it's history, the second chapter deals with installing mysql and some notes on installation for various distributions and operating systems. Chapter 3 gets into the meat of the book though, named simply "MySQL Basics" this is one of the best chapters in my opinion. It gets to the heart of things. Finding people skipping to this chapter wouldn't suprise me. This is where you find the information needed to start mysql, create databases, create tables, insert data, select data, and much more. One of the few things I would have changed in this book, is to make this section even LONGER than it is, and perhaps split it up even more. Chapter 3 is the last chapter that is "just readable" for readings sake, the following chapters are more for reference than for reading.
The rest of the chapters are as I stated, more for reference than reading. All of the examples are very detailed and have clear explanations for those commands that require it. Many of the SQL statement examples in chapter 4 are a full page and detailed with examples. The chapters on the various functions are detailed in the same way and are written in a clear, easy to understand fashion. Appendix A details the datatypes available and Appendix B details the different types of operators, Appendix C shows the many enviroment variables.
Even though I would have liked to see Chapter 3 even larger or even better, split up, the book does a great job of showing you examples and it does supply you with enough information to get started, even if your new to mysql. Concise and too the point, it's everything you've come to expect from a "Nutshell" book and more. It's yet another of my "must have" books. If you deal with mysql, you'll find this one of the books that doesn't just sit on the bookshelf collecting dust.
Original Review at:
https://www.usalug.org/phpBB2/viewtopic.php?p=81765
Sometimes You Feel Like a Nut...shell, June 03 2005
I have a few ‘Nutshell’ books in my library, and have found them to be a source I refer to time and time again. So, when I saw that O’Reilly had released a ‘Nutshell’ book on MySQL, I headed on over to my local bookstore and spent some time in a high-back chair perusing it’s pages.
Don’t let the size of the book fool you. The information it contains is well laid out into identifiable topics for easy reference. Since I have acquired this book, I have been able to find desired functions, statements and utilities more easily than before.
Lately, I am spending a considerable amount of my time tuning and optimizing SQL queries that appear throughout a large PHP application I am designing. I initially wrote the queries months ago, but with my newfound reference in hand, I have been able to significantly reduce the amount of execution time each query takes. One of the book’s pleasant surprises was the section regarding flow control functions, which lets me take my SQL query functionality far beyond where it ever has been.
The book also includes chapters on PERL, PHP and C APIs, which prove to be very readable. This little powerhouse packs a punch. I definitely recommend “MySQL in a Nutshell, A Desktop Quick Reference by Russell J.T. Dyer” to anyone developing applications that interface with MySQL, or to anyone who wants to get to know MySQL better.
For more information, go to:
https://www.oreilly.com/catalog/mysqlian/
-Brett Berry
PERL/PHP/JavaScript/MySQL
https://www.BrettBerry.com
Media reviews
"...the book does a great job of showing you examples and it does supply you with enough information to get started, even if your new to MySQL. Concise and too the point, it's everything you've come to expect from a "Nutshell" book and more. It's yet another of my "must have" books. If you deal with MySQL, you'll find this one of the books that doesn't just sit on the bookshelf collecting dust."
-- Dave Crouse, USA Linux User Group
"It's a convenient add-on pod for your overworked brain, containing all that fiddly information that you almostrecall by heart: administrative details; idiosyncrasies in the SQL dialect; and APIs in Perl, PHP, and C. Throughout the book are concrete examples specific to MySQL."
-- Rick Wayne, Software Development Magazine
"[The book includes] a superbly organized section on all the MySQL functions that are somewhere in the Canterbury Tales that is the MySQL User Manual but here organized by String, Date and Time, Math and then Flow Control functions. This is ninety pages just packed with useful tips, examples, and advisories. This really unlocks MySQL for me."
-- Jacques Surveyer, The Open Sourcery
"It's probably safe to say that the purpose of most Nutshell books is to provide a reference you can pull from the shelf and look up the syntax for an arcane command when needed. To say that this book fulfills that function, however, is to tell only part of the story. Not only does it offer a quick reference to MySQL statements and functions, but it also covers such topics as installation (on various platforms including Unix, Linux, NetWare, Windows, and Macintosh OS X), and the basics... The author is a Perl programmer/MySQL developer, and his mastery of the material shines through. As you read through the book, and this chapter in particular, you immediately realize that this is an author who could easily spout correct syntax in his sleep without missing a breath... there are many books on MySQL filling the bookshelves, but one that you must buy in order to have the necessary documentation for MySQL is MySQL in a Nutshell."
--Emmett Dulaney, Unix Review, July 2005
"It is a very comprehensive text that reads as easily as a favorite novel yet is concise enough to be your first 'go-to' on MySQL issues you may face day-in and day-out. It is truly the 'most advanced kingfisher' (cover animal) on the topic and, like the Pied kingfisher, it is lightweight and demonstrates keenly honed survival skills. I use MySQL daily and I find it very useful and enjoyable. I don't want to become an SQL guru or even a DBA, as a programmer, I enjoy having MySQL In A Nutshell close at hand so that I can focus on writing code. Thank you Mr. Dyer (and the folks at O'Reilly) for a job well done!"
-Rob Wehrli, Amazon.com review, January 2006
"At only just over 300 pages, this depth of detail is possible by keeping examples to the point: you don’t get waffle, you don’t get excess code blocks and you certainly don’t get picture after gratuitous picture to demonstrate a single point…We’ve waited too long for a MySQL in a Nutshell book, and this book satisfies completely."
--Paul Hudson, Linux Format, July 2005
Read all reviews
MySQL in a Nutshell
By Russell Dyer
May 2005
Pages: 348
Series: In a Nutshell
ISBN 10: 0-596-00789-2 |
ISBN 13: 9780596007898
(Average of 2 Customer Reviews)
This book has been updated—the edition you're requesting is OUT OF PRINT. Please visit the catalog page of the latest edition.
The latest edition is also available on Safari Books Online.
MySQL in a Nutshell covers all MySQL functions, as well as MySQL administration, and listings for the most important language APIs available to programmers. This wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned. It clearly documents every detail you need to master MySQL.
Full Description
MySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily.
MySQL in a Nutshell is the indispensable desktop reference to all MySQL functions. Programming language APIs for PHP, Perl, and C are covered, as well as all the popular MySQL utilities.
This invaluable resource clearly documents the details that experienced users need to take full advantage of this powerful database management system. Better yet, this wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned.
In addition to providing a thorough reference to MySQL statements and functions, the administrative utilities, and the most popular APIs, MySQL in a Nutshell includes several tutorial chapters to help newcomers get started. Moreover, each chapter covering an API begins with a brief tutorial so that, regardless of your level of experience in any given area, you will be able to understand and master unfamiliar territory.
MySQL in a Nutshell distills all the vital MySQL details you need on a daily basis into one convenient, well-organized book. It will save you hundreds of hours of tedious research or trial and error and put the facts you need to truly tap MySQL's capabilities at your fingertips.
Featured customer reviews
USA Linux Users Group Book Review, June 09 2006
Rating:
Submitted by
Crouse
[Respond | View]
MySQL in a Nutshell is for those new to mysql and also useful for those that are experienced with this database. As with most of the Nutshell books, this book is more of a complete reference for commands. Not really designed to be read cover to cover, it does provide an excellent reference for anyone that deals with the popular mysql database. The excellent examples and detailed explanations for SQL statements and the many functions make this a must have book for those just starting out, and a handy reference for those that have been using mysql for years.
The first chapter is the obligatory introduction to mysql and it's history, the second chapter deals with installing mysql and some notes on installation for various distributions and operating systems. Chapter 3 gets into the meat of the book though, named simply "MySQL Basics" this is one of the best chapters in my opinion. It gets to the heart of things. Finding people skipping to this chapter wouldn't suprise me. This is where you find the information needed to start mysql, create databases, create tables, insert data, select data, and much more. One of the few things I would have changed in this book, is to make this section even LONGER than it is, and perhaps split it up even more. Chapter 3 is the last chapter that is "just readable" for readings sake, the following chapters are more for reference than for reading.
The rest of the chapters are as I stated, more for reference than reading. All of the examples are very detailed and have clear explanations for those commands that require it. Many of the SQL statement examples in chapter 4 are a full page and detailed with examples. The chapters on the various functions are detailed in the same way and are written in a clear, easy to understand fashion. Appendix A details the datatypes available and Appendix B details the different types of operators, Appendix C shows the many enviroment variables.
Even though I would have liked to see Chapter 3 even larger or even better, split up, the book does a great job of showing you examples and it does supply you with enough information to get started, even if your new to mysql. Concise and too the point, it's everything you've come to expect from a "Nutshell" book and more. It's yet another of my "must have" books. If you deal with mysql, you'll find this one of the books that doesn't just sit on the bookshelf collecting dust.
Original Review at:
https://www.usalug.org/phpBB2/viewtopic.php?p=81765
Sometimes You Feel Like a Nut...shell, June 03 2005
Rating:
Submitted by Anonymous Reader [Respond | View]
I have a few ‘Nutshell’ books in my library, and have found them to be a source I refer to time and time again. So, when I saw that O’Reilly had released a ‘Nutshell’ book on MySQL, I headed on over to my local bookstore and spent some time in a high-back chair perusing it’s pages.
Don’t let the size of the book fool you. The information it contains is well laid out into identifiable topics for easy reference. Since I have acquired this book, I have been able to find desired functions, statements and utilities more easily than before.
Lately, I am spending a considerable amount of my time tuning and optimizing SQL queries that appear throughout a large PHP application I am designing. I initially wrote the queries months ago, but with my newfound reference in hand, I have been able to significantly reduce the amount of execution time each query takes. One of the book’s pleasant surprises was the section regarding flow control functions, which lets me take my SQL query functionality far beyond where it ever has been.
The book also includes chapters on PERL, PHP and C APIs, which prove to be very readable. This little powerhouse packs a punch. I definitely recommend “MySQL in a Nutshell, A Desktop Quick Reference by Russell J.T. Dyer” to anyone developing applications that interface with MySQL, or to anyone who wants to get to know MySQL better.
For more information, go to:
https://www.oreilly.com/catalog/mysqlian/
-Brett Berry
PERL/PHP/JavaScript/MySQL
https://www.BrettBerry.com
Media reviews
"...the book does a great job of showing you examples and it does supply you with enough information to get started, even if your new to MySQL. Concise and too the point, it's everything you've come to expect from a "Nutshell" book and more. It's yet another of my "must have" books. If you deal with MySQL, you'll find this one of the books that doesn't just sit on the bookshelf collecting dust."
-- Dave Crouse, USA Linux User Group
"It's a convenient add-on pod for your overworked brain, containing all that fiddly information that you almostrecall by heart: administrative details; idiosyncrasies in the SQL dialect; and APIs in Perl, PHP, and C. Throughout the book are concrete examples specific to MySQL."
-- Rick Wayne, Software Development Magazine
"[The book includes] a superbly organized section on all the MySQL functions that are somewhere in the Canterbury Tales that is the MySQL User Manual but here organized by String, Date and Time, Math and then Flow Control functions. This is ninety pages just packed with useful tips, examples, and advisories. This really unlocks MySQL for me."
-- Jacques Surveyer, The Open Sourcery
"It's probably safe to say that the purpose of most Nutshell books is to provide a reference you can pull from the shelf and look up the syntax for an arcane command when needed. To say that this book fulfills that function, however, is to tell only part of the story. Not only does it offer a quick reference to MySQL statements and functions, but it also covers such topics as installation (on various platforms including Unix, Linux, NetWare, Windows, and Macintosh OS X), and the basics... The author is a Perl programmer/MySQL developer, and his mastery of the material shines through. As you read through the book, and this chapter in particular, you immediately realize that this is an author who could easily spout correct syntax in his sleep without missing a breath... there are many books on MySQL filling the bookshelves, but one that you must buy in order to have the necessary documentation for MySQL is MySQL in a Nutshell."
--Emmett Dulaney, Unix Review, July 2005
"It is a very comprehensive text that reads as easily as a favorite novel yet is concise enough to be your first 'go-to' on MySQL issues you may face day-in and day-out. It is truly the 'most advanced kingfisher' (cover animal) on the topic and, like the Pied kingfisher, it is lightweight and demonstrates keenly honed survival skills. I use MySQL daily and I find it very useful and enjoyable. I don't want to become an SQL guru or even a DBA, as a programmer, I enjoy having MySQL In A Nutshell close at hand so that I can focus on writing code. Thank you Mr. Dyer (and the folks at O'Reilly) for a job well done!"
-Rob Wehrli, Amazon.com review, January 2006
"At only just over 300 pages, this depth of detail is possible by keeping examples to the point: you don’t get waffle, you don’t get excess code blocks and you certainly don’t get picture after gratuitous picture to demonstrate a single point…We’ve waited too long for a MySQL in a Nutshell book, and this book satisfies completely."
--Paul Hudson, Linux Format, July 2005
Read all reviews
"If you deal with MySQL, you'll find this one of the books that doesn't just sit on the bookshelf collecting dust."
--Dave Crouse, USA Linux User Group
©2009, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly
Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly |
More O'Reilly Sites
O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone O'Reilly FYI makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net |
Content Archive Business Technology Computer Technology Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design |