Cover image
Normal view MARC view ISBD view

MySQL Cookbook /

by DuBois, Paul.
Publisher: Beijing ; Sebastopol, CA : O'Reilly, c2007Edition: 2nd ed.Description: xxvi, 948 p. : ill. ; 24 cm.ISBN: 9780596527082 (pbk.); 059652708X (pbk.).Subject(s): SQL (Computer program language) | MySQL (Electronic resource)
Contents:
Using the mysql client program -- Writing MySQL-based programs -- Selecting data from tables -- Table management -- Working with strings -- Working with dates and times -- Sorting query results -- Generating summaries -- Obtaining and using metadata -- Importing and exporting data -- Generating and using sequences -- Using multiple tables -- Statistical techniques -- Handling duplicates -- Performing transactions -- Using stored routines, triggers, and events -- Introduction to MySQL on the Web -- Incorporating query results into Web pages -- Processing Web input with MySQL -- Using MySQL-based Web session management.
Summary: This book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time or expertise to solve MySQL problems from scratch. Each recipe explains how and why the code works, so you'll learn as you. This new edition covers MySQL 5.0 and its powerful new features, along with the older but still widespread MySQL 4.1.
Item type Location Call number Copy Status Date due
BOOK BOOK Foothills Lab QA76.73.S67 D587 2007 (Browse shelf) 1 Item lost

"Covers MySQL 4.0"--Cover.

"Solutions and examples for MySQL database developers"--Cover.

Includes bibliographical references (p. 917-920) and index.

Using the mysql client program -- Writing MySQL-based programs -- Selecting data from tables -- Table management -- Working with strings -- Working with dates and times -- Sorting query results -- Generating summaries -- Obtaining and using metadata -- Importing and exporting data -- Generating and using sequences -- Using multiple tables -- Statistical techniques -- Handling duplicates -- Performing transactions -- Using stored routines, triggers, and events -- Introduction to MySQL on the Web -- Incorporating query results into Web pages -- Processing Web input with MySQL -- Using MySQL-based Web session management.

This book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time or expertise to solve MySQL problems from scratch. Each recipe explains how and why the code works, so you'll learn as you. This new edition covers MySQL 5.0 and its powerful new features, along with the older but still widespread MySQL 4.1.

Any questions? Ask a Librarian.

Not finding what you are looking for? Request-It - InterLibrary Loan.

Languages: