MySQL Pocket Reference

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.

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.

Introduction	p. 1
MySQL 5	p. 2
Views	p. 3
Triggers	p. 3
Stored Procedures	p. 3
Cursors	p. 4
New Storage Engines	p. 4
Database Events	p. 5
Setup	p. 5
Downloading MySQL	p. 5
Configuration	p. 6
Startup	p. 8
Set the Root Password	p. 10
Replication	p. 10
Command-Line Tools	p. 12
Data Types	p. 15
Numerics	p. 16
Strings	p. 21
Dates	p. 26
Complex Types	p. 28
SQL	p. 30
Case Sensitivity	p. 31
Literals	p. 31
Identifiers	p. 33
Comments	p. 34
Commands	p. 35
Transaction Rules	p. 86
Operators	p. 87
Rules of Precedence	p. 87
Arithmetic Operators	p. 88
Comparison Operators	p. 89
Logical Operators	p. 91
Functions	p. 91
Aggregate Functions	p. 91
General Functions	p. 93
Storage Engines	p. 114
Stored Procedures and Functions	p. 115
Parameters	p. 116
Logic	p. 117
Handlers and Conditions	p. 122
Triggers	p. 123
Index	p. 125
Table of Contents provided by Ingram. All Rights Reserved.

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 Used, Rental and eBook copies of this book are 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.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

MySQL Pocket Reference

Summary

Author Biography

Table of Contents

Supplemental Materials