MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators, 9781449374020 (1449374026), O'Reilly, 2014

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

Comments

Amazing Books

Python for Data Mining Quick Syntax Reference

Apress, 2018

?Learn how to use Python and its structures, how to install Python, and which tools are best suited for data analyst work. This book provides you with a handy reference and tutorial on topics ranging from basic Python concepts through to data mining, manipulating and importing datasets, and data analysis.

...

Operating Systems: Concurrent and Distributed Software Design

Addison Wesley, 2003

Today's software systems rely on the concepts of concurrency, modularity and distribution, both within the design of the operating system and those systems that it supports. The modern approach of this book acknowledges that distributed systems are now commonplace and a reader is more likely to be using one than a centralized...

JUnit in Action

Manning Publications, 2003

A guide to unit testing Java applications (including J2EE applications) using the JUnit framework and its extensions, this book provides techniques for solving real-world problems such as unit testing legacy applications, writing real tests for real objects, automating tests, testing in isolation, and unit testing J2EE and database...

The Zend PHP Certification Practice Test Book - Practice Questions for the Zend Certified Engineer Exam

Marco Tabini, 2005

As the usage of PHP grows, the need for a globally-recognized credentials program for professional developers is becoming more and more important. The Zend Engineer Certification Program, launched by worldwide PHP leader Zend Technologies, finally creates a professional designation that represents consistently high-quality skills and knowledge in...

Microsoft Expression Design on Demand

Que, 2008

SEE HOW TO:

• Create, open, and save Expression Design documents

• Navigate documents easily by zooming and scrolling

• Understand how to use the Expression Design interface controls

...

Learning jQuery 1.3

Packt Publishing, 2009

Packed with great examples and clear explanations, this revised and updated version of Learning jQuery teaches you how to use jQuery 1.3. This book is for web designers who want to create interactive elements for their designs, and for developers who want to create the best user interface for their web applications. Basic JavaScript programming...