MySQL Cookbook

Paul DuBois

1010 pages, parution le 22/12/2002

Ajouter à une liste

Indisponible

Résumé

While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut.

MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.

The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:

Import data from external sources
Export data for use by external programs
Access MySQL from your web server
Use scripts with MySQL to read queries from a file
Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages
Construct queries that solve commonly-occurring questions
Interact with the server

This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.

Contents

Using the mysql Client Program
Writing MySQL-Based Programs
Record Selection Techniques
Working with Strings
Working with Dates and Times
Sorting Query Results
Generating Summaries
Modifying Tables with ALTER TABLE
Obtaining and Using Metadata
Importing and Exporting Data
Generating and Using Sequences
Using Multiple Tables
Statistical Techniques
Handling Duplicates
Performing Transactions
Introduction to MySQL on the Web
Incorporating Query Results into Web Pages
Processing Web Input with MySQL
Using MySQL-Based Web Session Management

A. Obtaining MySQL Software
B. JSP and Tomcat Primer
C. References

L'auteur - Paul DuBois

Paul DuBois is a writer, database administrator, and leader in the Open Source and MySQL communities. He contributed to the online documentation for MySQL and is the author MySQL and Perl for the Web (New Riders Publishing), and MySQL Cookbook, Using csh and tcsh, and Software Portability with imake (O'Reilly and Associates).

Caractéristiques techniques

	PAPIER
Éditeur(s)	O'Reilly
Auteur(s)	Paul DuBois
Parution	22/12/2002
Nb. de pages	1010
Format	17,7 x 23,2
Couverture	Broché
Poids	1263g
Intérieur	Noir et Blanc
EAN13	9780596001452