 |
MySQL Pocket Reference, 2nd Edition View Larger Image | George Reese
O'Reilly Media, Paperback, 2nd edition, Published July 2007, 126 pages, ISBN 0596514263 | List Price: $14.99
Our Price: $9.95
You Save: $5.04 (34% Off)
| | | Availability: In-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - MySQL Cookbook, 2nd Edition; Paul DuBois, $31.50, 37% Off!
- MySQL Stored Procedure Programming; Guy Harrison, et al, $27.95, 38% Off!
- CSS Pocket Reference, 3rd Edition; Eric A. Meyer, $6.95, 30% Off!
- SQL Pocket Guide, 2nd Edition; Jonathan Gennick, $9.95, 34% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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.
Table of Contents
Introduction
MySQL 5
Views
Triggers
Stored Procedures
Cursors
New Storage Engines
Database Events
Setup
Downloading MySQL
Configuration
Startup
Set the Root Password
Replication
Command-Line Tools
Data Types
Numerics
Strings
Dates
Complex Types
SQL
Case Sensitivity
Literals
Identifiers
Comments
Commands
Transaction Rules
Operators
Rules of Precedence
Arithmetic Operators
Comparison Operators
Logical Operators
Functions
Aggregate Functions
General Functions
Storage Engines
Stored Procedures and Functions
Parameters
Logic
Handlers and Conditions
Triggers
Index
About the Author
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.
|
|
