MySQL Cookbook / Paul DuBois.
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)
|Item type||Current location||Call number||Copy number||Status||Date due||Item holds|
|BOOK||Foothills Lab||QA76.73.S67 D587 2007 (Browse shelf)||1||Missing|
"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.