MySQL Stored Procedure Programming

Fülszöveg

Database/'Web Programming
O'REILLY
MySQL Stored Procedure Programming
Destined to be the bible of stored procedure development, this book is a resource that no real MySQL programmer can afford to be without. That's because the implementation of stored procedures in MySQL 5.0 is a huge milestone—one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures, functions, and triggers work.
Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. A companion web site contains thousands of lines of code that you can put to use immediately. The book consists of four major sections:
• Stored programming fundamentals—tutorial, using SQL in stored... Tovább

Fülszöveg

Database/'Web Programming
O'REILLY
MySQL Stored Procedure Programming
Destined to be the bible of stored procedure development, this book is a resource that no real MySQL programmer can afford to be without. That's because the implementation of stored procedures in MySQL 5.0 is a huge milestone—one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures, functions, and triggers work.
Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. A companion web site contains thousands of lines of code that you can put to use immediately. The book consists of four major sections:
• Stored programming fundamentals—tutorial, using SQL in stored programs, and error handling
• Building MySQL stored programs—transactions, built-in functions, stored functions, and triggers
• MySQL stored programs in applications—using stored programs with PHP, Perl, Python, Java, and .NET (C# and VB.NET)
• Optimizing MySQL stored programs—security, basic and advanced SQL tuning, optimization of stored program code, and programming best practices
Few in the MySQL world have substantial experience with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise. Guy is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on database technologies. Steven is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming. Between them, they have authored a dozen books.
"I didn't honestly believe a book could be written on this topic that wouldn't be too dry. But Guy and Steven show the depth of the subject and make the material available to readers. It was a wonderful read." —Brian Aker, Director of Architecture, MySQL AB
"The authors have an excellent grasp ofthe subject matter. Ifound the material easy to read, with lots of code examples. MySQL users should find this book an excellent resource."
—Arjen Lentz, Community Relations Manager, MySQL AB
"Guy and Steven have provided MySQL developers with a gem. They not only cover the nuts and bolts ofwriting stored procedures in MySQL, but alsó provide sound advice on designing database applications in the real world. In addition, they write with a sense of humor that makes the book a joy to read."
—James Cooper, Seattle, WA Vissza