Free Downloads
MySQL Pocket Reference: SQL Statements, Functions And Utilities And More (Pocket Reference (O'Reilly))

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 passwordMySQL data types, including numerics, strings, dates, and complex typesSQL syntax, commands, data types, operators, and functionsArithmetic, comparison and logical operatorsAggregate and general functionsStored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggersYou 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.

Paperback: 134 pages

Publisher: O'Reilly Media; 2 edition (July 27, 2007)

Language: English

ISBN-10: 0596514263

ISBN-13: 978-0596514266

Product Dimensions: 4.2 x 0.4 x 7 inches

Shipping Weight: 2.9 ounces (View shipping rates and policies)

Average Customer Review: 4.3 out of 5 stars  See all reviews (20 customer reviews)

Best Sellers Rank: #372,906 in Books (See Top 100 in Books) #59 in Books > Computers & Technology > Databases & Big Data > MySQL #174 in Books > Computers & Technology > Databases & Big Data > SQL #249 in Books > Computers & Technology > Databases & Big Data > Data Processing

Reese hits a solid triple to start the inning off and scores easily on the wild pitch thrown by the reader who says that the GRANT section is wrong.This book works easily and appropriately at your deskside. I found the book to be a very simple, easy-to-navigate reference text that presents the most important aspects of MySQL in the quickest, most logical manner.It is very easy to thumb through with every possible random page landing at a topic of interest. In a way, it was like working with a familiar dictionary, you know the kind, where you just kind of naturally crack it open near the word you're accessing and flip a couple of pages either direction to arrive at the exact reference location.In that vein, I'd perhaps recommend that the margins contain "bread crumbs" telling us where we are in the book, but it isn't necessary since thicker sections often obviate themselves with just another page turn. Each page does have the chapter title in the margin, so my point is really one of nit-pickieness rather than a true critique.To its credit, the layout of the book presents the content in a manner that follows the O'Reilly "risen bar" standard. It is easy to scan through the entire reference flipping pages as quickly as possible so that you are able to arrive at your sought information within as much as a second or two. The bold text draws your eye to the page and the size of the page allows one to capture everything in a single glance.In my usage of the book, I found it very accurate and useful. I am a regular MySQL user and the formatting is very familiar to me. I highly recommend this book. If you are already familiar with SQL and the basics of database schema design, this is the perfect reference.

MySQL Pocket Reference: SQL Statements, Functions and Utilities and more (Pocket Reference (O'Reilly)) SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) PHP: MySQL in 8 Hours, For Beginners, Learn PHP MySQL Fast! A Smart Way to Learn PHP MySQL, Plain & Simple, Learn PHP MySQL Programming Language in Easy Steps, A Beginner's Guide, Start Coding Today! SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Effective MySQL Optimizing SQL Statements (Oracle Press) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) Expert T-SQL Window Functions in SQL Server MYSQL Programming Professional Made Easy 2nd Edition: Expert MYSQL Programming Language Success in a Day for any Computer User! (MYSQL, Android programming, ... JavaScript, Programming, Computer Software) BILL O'REILLY - SERIES READING ORDER (SERIES LIST) - IN ORDER: KILLING JESUS, KILLING PATTON, KILLING LINCOLN, KILLING KENNEDY, KILLING REAGAN, HITLER'S LAST DAYS, THE O'REILLY FACTOR & MANY MORE! Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O'Reilly)) Python Pocket Reference (Pocket Reference (O'Reilly)) GDB Pocket Reference (Pocket Reference (O'Reilly)) LINQ Pocket Reference (Pocket Reference (O'Reilly)) Linux iptables Pocket Reference (Pocket Reference (O'Reilly)) XML Pocket Reference (Pocket Reference (O'Reilly)) Microsoft Excel 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide) Microsoft Excel 2010 Functions & Formulas Quick Reference Guide (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide) Haunted Tales - A Mary O'Reilly Paranormal Mystery - Book Fifteen (Mary O'Reilly Series 15) Deadly Circumstances - A Mary O'Reilly Paranormal Mystery (Book 16) (Mary O'Reilly Paranormal Mysteries)