Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
MySQL Cookbook Review by Sean P. Hull
Quickstart to MySQL Development
I really enjoy cookbooks because of their no nonsense organization. This MySQL book exactly fits that description. Chances are just scanning the table of contents you'll find the question you are asking with the answer and explanation at your fingertips.
Nuggets of information I found quickly include: paging producing HTML output with the mysql client, checking and changing a tables storage engine, working with fulltext searches, summary and grouping query examples, importing data from CSV, exporting in various formats, dealing with auto_increment columns, sequences, deletes, gaps, and so on. Also handling duplicates, detecting, eliminating, working with transactions, and a whole lot more.
The book is mainly geared towards web applications and MySQL. The languages that they cover include Perl, Ruby, PHP, Java, Python. If you're using any of those languages for your web application, it is more than likely you want a copy of this book. It's very quick and painless to lookup how to do something, and not have to wade through tons of information that's not relevant to you.
The target audience for this book is really developers not DBAs, so keep that in mind. If you're doing web development in Ruby, PHP, Perl, Python or Java, you should consider this book. It concentrates solely on the how to do specific things, so you won't get weighed down by too much theory and so on. With that in mind, it's not per se a book on performance, testing, benchmarking and profiling applications in those languages, so if that is what you need, you'll require additional material.