MySql Stored Procedure Programming Illustrated Edition

good product

I bought this to solve a problem. I read through about 70 percent of the book, at which point I felt ready to tackle the problem, and I did so successfully. Sure, you can Google how to do some of this stuff, but the book lays it out in an incremental fashion, in depth and in detail. Each example is broken down line by line in a chart. There's plenty of explanation, and it will cover topics and features you may not know existed if you're just hacking something together from Google. The book will turn you from a "I know some SQL" guy to a "I'm a DB professional."If you're a developer, you may find that certain tasks are easier to code in the database. Batch oriented tasks, scheduled tasks, or processes triggered by a change in a value in the database are good candidates for a stored procedure solution.The only downside from my experience is that I ordered the Kindle edition, and the screenshots are too small for the Kindle 2 to read comfortably. This book requires a DX-size Kindle.

Being fairly new to MySQL (but not to programming) I needed to develop an application using PHP/OOP with MySQL and stored procedures. This book is pretty concise and got me going quickly. At the time, I searched the Amazon book offerings and also books on the shelf at Barnes & Noble. This book is the only one providing clear and concise material on the subject.I do wish the coverage would have been more detailed using PHP data objects (PDO) in combination with stored procedures that use various combinations of INPUT, OUTPUT and INPUT-OUTPUT parameters in addition to exception processing, etc. That would have been great but then, this isn't a PHP book. Too bad most PHP books seem to focus more on the basics of the language and don't delve into the weighty matters of real-world commercial application development.

This is a terrific book if you want to learn Stored Procedures. When you get it, go to the back and read the better practices sections - it is excellent, as is the rest of the book.

I've Been working with MySQL for 14 years but never used Stored Procedures until I changed jobs. When I needed to produced reports from millions of rows I knew the simple queries weren't going to cut it. This book will get you up and running with stored procedures, triggers and functions in no time.

I didn't know much beyond simple select queries and needed to grind through some data. Perl would have been a better fit, but I felt a relational database made sense at the time of request for the data. If you need to make single table row relationships, stored procedures are kind of the only option.

This is a fantastic book. I work as a software tester that works with MySQL in some capacity every day. With the help of this book I was able not only understand the stored procedures our developers were writing up but I was able to write my own procedures and functions with ease.It's a fairly dry book but the information is fantastic. I would highly recommend this book to anyone who wants to learn more about stored procedures using MySQL.

Covers the intended topic in good details nice flow and ample examples

I bought this recently to get into developing and expanding my use of MySQL to use triggers and stored procedures.Previously been using V4 heavily and whilst I had some prior experience of triggers and stored procedures on SQL Server and Oracle it was not extensive. This book whilst appears a little long winded in places actually provides a very logical approach to developing stored procedures, improving your skills and even tuning/best practice to get the most performance out of your database.This is a book for those with some prior experience of SQL and perhaps touched on triggers/stored procedures who want to expand.

As you would expect. The book was in good condition as describedand delivery was fast. Very much appreciated.

I ordered this book as I had to learn MySQL Stored Procedures for a new job. The book is literally the Bible on the subject, and also goes deeply into DB triggers which could fill a book in itself.

Does what it should. Not as up to date as needed to be but good guide.

Este libro es fantástico, con todo detalle te explica los procedimientos que se pueden almacenar en MYSQL. Explica con detenimiento el acceso a datos MySQL + PHP Fantástico para ir más allá creando subrutinas almacenadas y creando procedimientos a los que llamar desde el navegador. Nivel elevado, se dirige a programadores con experiencia en SQL.