Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    What I'm Giving | November 29, 2014

    Neil Patrick Harris: IMG Neil Patrick Harris: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer

MySQL Pocket Reference: SQL Functions and Utilities

by

MySQL Pocket Reference: SQL Functions and Utilities Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

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.

Synopsis:

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.

Synopsis:

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.

About the Author

George Reese is the founder and President of Valtira LLC inMinneapolis, 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

Chapter 1: MySQL Pocket Reference

Product Details

ISBN:
9780596514266
Author:
Reese, George
Publisher:
O'Reilly Media
Author:
Dyer, Russell J. T.
Subject:
Programming Languages - SQL
Subject:
Relational databases
Subject:
Database management
Subject:
Reference - General
Subject:
Computer Languages-SQL
Subject:
MySQL;database;system administration
Subject:
MySQL;SQL;database
Subject:
Data processing
Subject:
CourseSmart Subject Description
Edition Number:
2
Edition Description:
Second Edition
Series:
Pocket Reference (O'Reilly)
Publication Date:
20070731
Binding:
TRADE PAPER
Language:
English
Pages:
134
Dimensions:
9 x 6 x 1.14 in 1.69 lb

Other books you might like

  1. Regular Expression Pocket Reference:... Used Trade Paper $10.50
  2. C++ Pocket Reference Used Trade Paper $6.00
  3. Perl Pocket Reference 4TH Edition Used Trade Paper $5.50
  4. HTTP Pocket Reference (Pocket Reference)
    New Trade Paper $9.95
  5. HTML and XHTML Pocket Reference... Used Trade Paper $6.95
  6. Grammar Snobs Are Great Big Meanies:...
    Used Trade Paper $6.50

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » Beginning and Reference
Computers and Internet » Database » Applications
Computers and Internet » Database » MySQL
Computers and Internet » Database » SQL
Computers and Internet » Nutshell » General

MySQL Pocket Reference: SQL Functions and Utilities New Trade Paper
0 stars - 0 reviews
$14.99 In Stock
Product details 134 pages O'Reilly Media - English 9780596514266 Reviews:
"Synopsis" by ,
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.
"Synopsis" by ,
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.
"Synopsis" by ,

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.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.