Author(s): Steven Feuerstein, Guy Harrison
Publisher: O'Reilly
Year: Mar 2006
ISBN: 0596100892
Language: English
File type: CHM
Pages: 636
Size (for download): 5.4 MB
MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You'll learn how to build and maintain stored programs -- covering transactions, stored functions, and triggers -- and how to call and use MySQL-based stored procedures in a variety of languages, including PHP, Perl, Python, .NET, and Java. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.
The implementation of stored procedures in MySQL 5.0 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 work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.
In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.
MySQL's new procedural language has a straightforward syntax, making it easy to write simple programs. But it's not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.
Additional not by me (ganelon):
The examples are included in the following archives organized by chapter. Each example is named according to the example in text (eg Ex01-01.sql is the text of example 01 in Chapter 01). There are also some project files in Eclipse and Visual Studio format for the Java and .NET chapters.
TABLE OF CONTENT:
Chapter 01 - Introduction to MySQL Stored Programs
Chapter 02 - MySQL Stored Programming Tutorial
Chapter 03 - Language Fundamentals
Chapter 04 - Blocks, Conditional Statements, and Iterative Programming
Chapter 05 - Using SQL in Stored Programming
Chapter 06 - Error Handling
Chapter 07 - Creating and Maintaining Stored Programs
Chapter 08 - Transaction Management
Chapter 09 - MySQL Built-in Functions
Chapter 10 - Stored Functions
Chapter 11 - Triggers
Chapter 12 - Using MySQL Stored Programs in Applications
Chapter 13 - Using MySQL Stored Programs with PHP
Chapter 14 - Using MySQL Stored Programs with Java
Chapter 15 - Using MySQL Stored Programs with Perl
Chapter 16 - Using MySQL Stored Programs with Python
Chapter 17 - Using MySQL Stored Programs with .NET
Chapter 18 - Stored Program Security
Chapter 19 - Tuning Stored Programs and Their SQL
Chapter 20 - Basic SQL Tuning
Chapter 21 - Advanced SQL Tuning
Chapter 22 - Optimizing Stored Program Code
Chapter 23 - Best Practices in MySQL Stored Program Development
Download :
http://rapidshare.com/files/106841668/Oreilly.MySQL.Pocket.Reference.eBook-LiB.chm
