MySQL Pocket Reference : SQL Functions and Utilities

  • ISBN13:


  • ISBN10:


  • Edition: 2nd
  • Format: Paperback
  • Copyright: 2007-07-17
  • Publisher: Oreilly & Associates Inc
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $14.99 Save up to $2.25
  • Buy New


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


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. MySQL 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.

Author Biography

George Reese is the founder and President of Valtira LLC in
Minneapolis, MN and author of technology books such as the MySQL Pocket Reference, Database Programming with JDBC and Java, and Java Database Best Practices. Throughout the Internet era, he has spent his career applying enterprise and web technologies to the marketing domain. He is the creator of the Simplicis Marketing Dashboard, the core product from Valtira.

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 and two daughters.

Table of Contents

Introductionp. 1
MySQL 5p. 2
Viewsp. 3
Triggersp. 3
Stored Proceduresp. 3
Cursorsp. 4
New Storage Enginesp. 4
Database Eventsp. 5
Setupp. 5
Downloading MySQLp. 5
Configurationp. 6
Startupp. 8
Set the Root Passwordp. 10
Replicationp. 10
Command-Line Toolsp. 12
Data Typesp. 15
Numericsp. 16
Stringsp. 21
Datesp. 26
Complex Typesp. 28
SQLp. 30
Case Sensitivityp. 31
Literalsp. 31
Identifiersp. 33
Commentsp. 34
Commandsp. 35
Transaction Rulesp. 86
Operatorsp. 87
Rules of Precedencep. 87
Arithmetic Operatorsp. 88
Comparison Operatorsp. 89
Logical Operatorsp. 91
Functionsp. 91
Aggregate Functionsp. 91
General Functionsp. 93
Storage Enginesp. 114
Stored Procedures and Functionsp. 115
Parametersp. 116
Logicp. 117
Handlers and Conditionsp. 122
Triggersp. 123
Indexp. 125
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review