MySQL Pocket Reference

SQL Functions and Utilities

Author: George Reese

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596551698

Category: Computers

Page: 134

View: 2198

DOWNLOAD NOW »

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.

MySQL in a Nutshell

A Desktop Quick Reference

Author: Russell J.T. Dyer

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449379377

Category: Computers

Page: 566

View: 4859

DOWNLOAD NOW »

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.

MySQL Cookbook

Solutions for Database Developers and Administrators

Author: Paul DuBois

Publisher: "O'Reilly Media, Inc."

ISBN: 1449374158

Category: Computers

Page: 866

View: 3806

DOWNLOAD NOW »

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

MySQL Reference Manual

Documentation from the Source

Author: Michael Widenius,David Axmark,MySQL AB

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596002657

Category: Computers

Page: 802

View: 7589

DOWNLOAD NOW »

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

XSLT 1.0 Pocket Reference

Author: Evan Lenz

Publisher: "O'Reilly Media, Inc."

ISBN: 0596100086

Category: Computers

Page: 172

View: 1860

DOWNLOAD NOW »

XSLT is an essential tool for converting XML into other kinds of documents: HTML, PDF file, and many others. It's a critical technology for XML-based platforms such as Microsoft .NET, Sun Microsystems' Sun One, as well as for most web browsers and authoring tools. As useful as XSLT is, however, most people have a difficult time getting used to its peculiar characteristics. The ability to use advanced techniques depends on a clear and exact understanding of how XSLT templates work and interact. The XSLT 1.0 Pocket Reference from O'Reilly wants to make sure you achieve that level of understanding. With its concise approach, this handy pocket guide quickly gets you up to speed on XSLT 1.0 so you can covert XML like a seasoned pro. In addition to covering the basics of stylesheet structure, it also explains how to: use template rules create a result tree apply conditional processing transform multiple source documents employ number formatting Thanks to their convenient, quick-reference format, O'Reilly's Pocket References spare you from having to hunt through larger books for answers. They deliver just what you need to get the job done in a timely fashion. And the XSLT 1.0 Pocket Reference is no different--it's the ideal companion to have at your desk when you need an answer fast.

PHP Quick Scripting Reference

Author: Mikael Olsson

Publisher: Apress

ISBN: 1430262842

Category: Computers

Page: 140

View: 1948

DOWNLOAD NOW »

The PHP Quick Scripting Reference is a condensed scripting code and syntax reference to the PHP scripting language, the most popular Web scripting language in use today. It presents the essential PHP script in a well-organized format that can be used as a handy reference. You won’t find any technical jargon, bloated samples, drawn out history lessons or witty stories in this book. What you will find is a Web scripting language reference that is concise, to the point and highly accessible. The book is packed with useful information and is a must-have for any PHP programmer or Web developer In the PHP Quick Scripting Reference, you will find: A concise reference to the PHP scripting language syntax. Short, simple and focused code examples. A well laid out table of contents and a comprehensive index allowing easy review.

R in a Nutshell

A Desktop Quick Reference

Author: Joseph Adler

Publisher: "O'Reilly Media, Inc."

ISBN: 1449358225

Category: Computers

Page: 724

View: 9581

DOWNLOAD NOW »

If you’re considering R for statistical computing and data visualization, this book provides a quick and practical guide to just about everything you can do with the open source R language and software environment. You’ll learn how to write R functions and use R packages to help you prepare, visualize, and analyze data. Author Joseph Adler illustrates each process with a wealth of examples from medicine, business, and sports. Updated for R 2.14 and 2.15, this second edition includes new and expanded chapters on R performance, the ggplot2 data visualization package, and parallel R computing with Hadoop. Get started quickly with an R tutorial and hundreds of examples Explore R syntax, objects, and other language details Find thousands of user-contributed R packages online, including Bioconductor Learn how to use R to prepare data for analysis Visualize your data with R’s graphics, lattice, and ggplot2 packages Use R to calculate statistical fests, fit models, and compute probability distributions Speed up intensive computations by writing parallel R programs for Hadoop Get a complete desktop reference to R

JavaScript Pocket Reference

Author: David Flanagan

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596552152

Category: Computers

Page: 138

View: 4282

DOWNLOAD NOW »

JavaScript--the powerful, object-based scripting language that can be embedded directly into HTML pages--has earned its place in the web developer's toolkit, to the extent that it's now considered required knowledge for web developers. You can use JavaScript to create dynamic, interactive applications that run completely within a web browser. JavaScript is also the language of choice for developing Dynamic HTML content. Because its syntax is based on the popular programming languages C, C++, and Java, JavaScript is familiar and easy to learn for experienced programmers. At the same time, it's an interpreted scripting language, providing a flexible, forgiving programming environment for new programmers. The JavaScript Pocket Reference, 2nd Edition, provides a complete overview of the core JavaScript language and client-side scripting environment, as well as quick-reference material on core and client-side objects, methods, and properties. The new edition has been revised to cover JavaScript 1.5, and is particularly useful for developers working with the standards-compliant web browsers, such as Internet Explorer 6, Netscape 7, and Mozilla. Ideal as an introduction for beginners and a quick reference for advanced developers, this pocket-sized book is easy to take anywhere and serves as the perfect companion volume to the bestselling JavaScript: The Definitive Guide, 4th Edition. O'Reilly's Pocket References have become a favorite among developers everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point and need to get to the answer quickly, the new JavaScript Pocket Reference is the book you'll want close at hand.

PHP for the Web

Visual QuickStart Guide

Author: Larry Ullman

Publisher: Peachpit Press

ISBN: 0134301889

Category: Computers

Page: 528

View: 3251

DOWNLOAD NOW »

Learn PHP programming the quick and easy way! With PHP for the Web: Visual QuickStart Guide readers can start from the beginning to get a tour of the programming language, or look up specific tasks to learn just what they need to know. This task-based visual reference guide uses step-by-step instructions and plenty of screenshots to teach beginning and intermediate users this popular open-source scripting language. Author Larry Ullman guides readers through the ins and outs of both PHP 5 and PHP 7, and offers more efficient ways to tackle common needs. Both beginning users, who want a thorough introduction to the technology, and more intermediate users, who are looking for a convenient reference, will find what they need here--in straightforward language and through readily accessible examples. Easy visual approach uses demonstrations and real-world examples to guide you through dynamic web development using PHP and show you what to do step by step. Concise steps and explanations let you get up and running in no time. Essential reference guide keeps you coming back again and again. Whether you’re a programming newbie or an experienced veteran learning PHP for the first time, this book will teach you all you need to know, including the latest changes in PHP and more efficient ways to tackle common needs.

jQuery Pocket Reference

Read Less, Learn More

Author: David Flanagan

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449302771

Category: Computers

Page: 160

View: 6865

DOWNLOAD NOW »

"As someone who uses jQuery on a regular basis, it was surprising to discover how much of the library I’m not using. This book is indispensable for anyone who is serious about using jQuery for non-trivial applications."-- Raffaele Cecco, longtime developer of video games, including Cybernoid, Exolon, and Stormlord jQuery is the "write less, do more" JavaScript library. Its powerful features and ease of use have made it the most popular client-side JavaScript framework for the Web. Ideal for JavaScript developers at all skill levels, this book is jQuery's trusty companion: the definitive "read less, learn more" guide to the library. jQuery Pocket Reference explains everything you need to know about jQuery, completely and comprehensively. You'll learn how to: Select and manipulate document elements Alter document structure Handle and trigger events Create visual effects and animations Script HTTP with Ajax utilities Use jQuery's selectors and selection methods, utilities, plugins and more The 25-page quick reference summarizes the library, listing all jQuery methods and functions, with signatures and descriptions.

High Performance MySQL

Optimization, Backups, and Replication

Author: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko

Publisher: "O'Reilly Media, Inc."

ISBN: 1449332501

Category: Computers

Page: 826

View: 5954

DOWNLOAD NOW »

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies—including new tools for hot online backups

MySQL Troubleshooting

What To Do When Queries Don't Work

Author: Sveta Smirnova

Publisher: "O'Reilly Media, Inc."

ISBN: 1449330231

Category: Computers

Page: 266

View: 380

DOWNLOAD NOW »

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL. Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence. Understand the source of a problem, even when the solution is simple Handle problems that occur when applications run in multiple threads Debug and fix problems caused by configuration options Discover how operating system tuning can affect your server Use troubleshooting techniques specific to replication issues Get a reference to additional troubleshooting techniques and tools, including third-party solutions Learn best practices for safe and effective troubleshooting—and for preventing problems

MySQL Administrator's Bible

Author: Sheeri K. Cabral,Keith Murphy

Publisher: John Wiley & Sons

ISBN: 1118080580

Category: Computers

Page: 888

View: 6212

DOWNLOAD NOW »

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Managing & Using MySQL

Open Source SQL Databases for Managing Information & Web Sites

Author: Tim King,George Reese,Randy Yarger,Hugh E. Williams

Publisher: "O'Reilly Media, Inc."

ISBN: 1449316786

Category: Computers

Page: 444

View: 4376

DOWNLOAD NOW »

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

PHP Pocket Reference

PHP in Your Pocket

Author: Davey Shafik

Publisher: O'Reilly Media

ISBN: 9781491969090

Category: Computers

Page: 200

View: 5642

DOWNLOAD NOW »

Updated to cover PHP 7, the third edition of this compact reference is the perfect toolbox full of need-to-know information for experienced PHP programmers. Author Davey Shafik provides a complete revision to this reference guide to cover milestones PHP has made in the last decade, including everything from modernizations with PHP 5.x to incredible speed and performance improvements with PHP 7 and beyond. In addition to the focus on PHP 7, this new edition also covers the differences from PHP 5.6, the last version of PHP 5 currently supported. Get need-to-know answers on PHP syntax from arrays and loops to scalar types and variables Make the most of modern PHP with new sections on PSR Standards, Composer, Web Requests, and more Find answers on the job quickly with a quick-lookup index Use installation appendices for Mac, Windows, and Linux users

Eclipse IDE Pocket Guide

Using the Full-Featured IDE

Author: Ed Burnette

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596553432

Category: Computers

Page: 130

View: 5288

DOWNLOAD NOW »

Eclipse is the world's most popular IDE for Java development. And although there are plenty of large tomes that cover all the nooks and crannies of Eclipse, what you really need is a quick, handy guide to the features that are used over and over again in Java programming. You need answers to basic questions such as: Where was that menu? What does that command do again? And how can I set my classpath on a per-project basis? This practical pocket guide gets you up to speed quickly with Eclipse. It covers basic concepts, including Views and editors, as well as features that are not commonly understood, such as Perspectives and Launch Configurations. You'll learn how to write and debug your Java code--and how to integrate that code with tools such as Ant and JUnit. You'll also get a toolbox full of tips and tricks to handle common--and sometimes unexpected--tasks that you'll run across in your Java development cycle. Additionally, the Eclipse IDE Pocket Guide has a thorough appendix detailing all of Eclipse's important views, menus, and commands. The Eclipse IDE Pocket Guide is just the resource you need for using Eclipse, whether it's on a daily, weekly, or monthly basis. Put it in your back pocket, or just throw it in your backpack. With this guide in hand, you're ready to tackle the Eclipse programming environment.

Flex & Bison

Text Processing Tools

Author: John Levine

Publisher: "O'Reilly Media, Inc."

ISBN: 1449391974

Category: Computers

Page: 292

View: 7000

DOWNLOAD NOW »

If you need to parse or process text data in Linux or Unix, this useful book explains how to use flex and bison to solve your problems quickly. flex & bison is the long-awaited sequel to the classic O'Reilly book, lex & yacc. In the nearly two decades since the original book was published, the flex and bison utilities have proven to be more reliable and more powerful than the original Unix tools. flex & bison covers the same core functionality vital to Linux and Unix program development, along with several important new topics. You'll find revised tutorials for novices and references for advanced users, as well as an explanation of each utility's basic usage and simple, standalone applications you can create with them. With flex & bison, you'll discover the wide range of uses these flexible tools offer. Address syntax crunching that regular expressions tools can't handle Build compilers and interpreters, and handle a wide range of text processing functions Interpret code, configuration files, or any other structured format Learn key programming techniques, including abstract syntax trees and symbol tables Implement a full SQL grammar-with complete sample code Use new features such as pure (reentrant) lexers and parsers, powerful GLR parsers, and interfaces to C++

Apache 2 Pocket Reference

For Apache Programmers & Administrators

Author: Andrew Ford

Publisher: "O'Reilly Media, Inc."

ISBN: 0596518889

Category: Computers

Page: 195

View: 4678

DOWNLOAD NOW »

Apache remains the most widely used Web server platform, running more than half of the world's Web sites. This pocket reference guide features up-to-date information for Apache administrators.

Learning MySQL

Author: Seyed Tahaghoghi,Hugh E. Williams

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008643

Category: Computers

Page: 598

View: 7337

DOWNLOAD NOW »

Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.