- Shopping Bag ( 0 items )
This new edition covers MySQL 5.0 and its powerful new features, along with the older but still widespread MySQL 4.1. You'll find ways ...
This new edition covers MySQL 5.0 and its powerful new features, along with the older but still widespread MySQL 4.1. You'll find ways to formulate queries with SQL using the mysql client program and methods for writing programs that interact with the MySQL server through an API. There are plenty of new examples for using Perl, PHP, Python, Java, and even Ruby to retrieve and display data. And the book is now updated to include subqueries, views, stored routines, triggers, and events.
This quick-solution resource also offers recipes to: Access data from multiple tables at the same time, Find matches or mismatches between rows in two tables, Store images into MySQL and retrieve them for display in web pages, Enable strict mode to prevent entry of bad data into your database, Create database events that execute according to a schedule. MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it assists you in developing applications yourself by helping you get past problems that have you stumped.
DuBois 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 readers can insert directly into their applications.
|1||Using the mysql client program||1|
|2||Writing MySQL-based programs||45|
|3||Selecting data from tables||131|
|5||Working with strings||171|
|6||Working with dates and times||213|
|7||Sorting query results||273|
|9||Obtaining and using metadata||353|
|10||Importing and exporting data||395|
|11||Generating and using sequences||481|
|12||Using multiple tables||517|
|16||Using stored routines, triggers, and events||643|
|17||Introduction to MySQL on the Web||661|
|18||Incorporating query results into Web pages||697|
|19||Processing Web input with MySQL||761|
|20||Using MySQL-based Web session management||841|
Posted January 5, 2005
MySQL Cookbook is not a beginner's 'how-to' instruction manual, but a comprehensive problem solving tool for constructing, optimizing and troubleshooting a wide variety of MySQL queries. A must have for anyone who gets stumped from time to time with an odd situation, or who wants to tweak their code.
1 out of 1 people found this review helpful.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.