| ||||||||||||
|
Frequently Bought Together
Customers Who Bought This Item Also Bought
High Performance MySQL: Optimization, Backups, Replication, and More by Arjen Lentz |
by Adam Trachtenberg
|
by Guy Harrison
|
by Hugh E Williams
|
by Chris Shiflett
|
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Product Description
Review
"...MySQL Cookbook tells you exactly how to solve literally hundreds of problems that you are likely to encounter in getting a MySQL database solution up and running." - Computer Trade Shopper, November 2003
--This text refers to an alternate
Paperback
edition.
Product Description
Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the 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. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well. Other recipes in the book teach you to: access data from multiple tables at the same time; use SQL to select, sort, and summarize rows; find matches or mismatches between rows in two tables; determine intervals between dates or times, including age calculations; store images into MySQL and retrieve them for display in web pages; get LOAD DATA to read your data files properly or find which values in the file are invalid; use strict mode to prevent entry of bad data into your database; copy a table or a database to another server; generate sequence numbers to use as unique row identifiers; create database events that execute according to a schedule; and a lot more. "MySQL Cookbook" doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Do Customers Ultimately Buy After Viewing This Item?
 |
56% buy the item featured on this page: MySQL Cookbook �24.53 |
 |
19% buy High Performance MySQL: Optimization, Backups, Replication, and More �20.13 |
 |
10% buy MySQL (Developer's Library) �16.00 |
 |
8% buy Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites �15.96 |
Customer Reviews
|
Share your thoughts with other customers:
Create your own review
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
3 of 4 people found the following review helpful:
5.0 out of 5 stars
Does Exactly What It Says On The Tin,
This review is from: MySQL Cookbook (Paperback)
A few pages past the table of contents, I had solved two issues that had been bugging me since my last install. It was pretty minor stuff, but could I as heck find the answers online. It just shows what research, presentation, and quality control can achieve. So, another score for books over bytes.
The layout is uncluttered, and you can usually get the gist without reading through pages of preamble and exposition. The examples are practical and adaptable (no long and complex routines found on some sites) so they can almost be cut and pasted into your own applications. As your applications develop, there's always something else you can add. The only downside is that it's a book - a few mods to MySQL and you might have to fork out for the next revision. Still, I should have got my money's worth by then.
5.0 out of 5 stars
Great Book,
By
This review is from: MySQL Cookbook (Paperback)
It is not for the complete beginner, but you don't have to be too far off to get some real benefit from using this book.
The discussions about why you would use a particular technique are excellent too. In my opinion it is great. I bought it and I am still using it.
4.0 out of 5 stars
Good book, recommanded,
By
This review is from: MySQL Cookbook (Paperback)
I like the style of the book which tackles the problems encountered rather than introducing theories chapter by chapter.
The reason I gave it a 4 is that it didn't cover some more advanced skills for database admin such as database management and securities.
Share your thoughts with other customers: Create your own review
|
Most Recent Customer Reviews
5.0 out of 5 stars
Teaches you SQL
Explains by example so many common queries you'll be able to solve a wide variety of problems instantly.
Published on 31 Mar 2006 by darreninlondon
|
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Applications > MySQL
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Databases > Java & Databases
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Languages > Java > XML
- Books > Computing & Internet > Programming > Languages > PHP
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
