Synopses & Reviews
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.
The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.
Inside, you'll find:
- A thorough reference to MySQL statements, functions, and administrative utilities
- Several tutorial chapters to help newcomers get started
- Programming language APIs for PHP, Perl, and C
- Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory
- New chapters on replication, triggers, and stored procedures
- Plenty of new examples of how MySQL is used in practice
- Useful tips to help you get through the most difficult subjects
Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell
has precisely what it takes.
To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.
Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:
- How to configure MySQL, such as setting the root password
- MySQL data types, including numerics, strings, dates, and complex types
- SQL syntax, commands, data types, operators, and functions
- Arithmetic, comparison and logical operators
- Aggregate and general functions
- Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers
You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference
is the book you want to have.
Easy to take and use anywhere, this little book provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure.
Completely revised for the latest version of the MySQL database, this book is a comprehensive reference to system commands and programming information, including the new features for version 5.1.
About the Author
George Reese is the founder of two Minneapolis-based companies, enStratus Networks LLC (maker of high-end cloud infrastructure management tools) and Valtira LLC (maker of the Valtira Online Marketing Platform). Over the past 15 years, George has authored a number of technology books, including MySQL Pocket Reference, Database Programming with JDBC and Java, Java Database Best Practices, and the upcoming Web Architecture and Programming in the Cloud.
Throughout the Internet era, George has spent his career building enterprise tools for developers and delivering solutions to the marketing domain. He was an influential force in the evolution of online gaming through the creation of a number of Open Source MUD libraries and he created the first JDBC driver in 1996-the Open Source mSQL-JDBC. Most recently, George has been involved in the development of systems to support the deployment of transactional web applications in the cloud.
George holds a BA in Philosophy from Bates College in Lewiston, Maine and an MBA from the Kellogg School of Management in Evanston, Illinois. He currently lives in Minnesota with his wife Monique and his daughters Kyra and Lindsey.
Table of Contents
PrefaceIntroduction and TutorialsChapter 1: Introduction to MySQLChapter 2: Installing MySQLChapter 3: MySQL BasicsSQL Statements and FunctionsChapter 4: Security and User Statements and FunctionsChapter 5: Database and Table Schema StatementsChapter 6: Data Manipulation Statements and FunctionsChapter 7: Table and Server Administration Statements and FunctionsChapter 8: Replication Statements and FunctionsChapter 9: Stored Routines StatementsChapter 10: Aggregate Clauses, Aggregate Functions, and SubqueriesChapter 11: String FunctionsChapter 12: Date and Time FunctionsChapter 13: Mathematical FunctionsChapter 14: Flow Control FunctionsMySQL Server and Client ToolsChapter 15: MySQL Server and ClientChapter 16: Command-Line UtilitiesAPIs and ConnectorsChapter 17: C APIChapter 18: Perl APIChapter 19: PHP APIAppendixesData TypesOperatorsServer and Environment VariablesColophon