|
|
简介：
| MySQL Stored Procedure Programming | | By Steven Feuerstein, Guy Harrison | | ............................................... | | Publisher: O'Reilly | | Pub Date: March 2006 | | Print ISBN-10: 0-596-10089-2 | | Print ISBN-13: 978-0-59-610089-6 | | Pages: 636 |
《英文版本》
MySQL.Stored.Procedure.Programming.zip
下载：
《中文版本》
原著：Steven Feuerstein, Guy Harrison
MySQL存储过程编程教程
翻译作者： drekey@gmail.com （MySQLpub.com版主）
地址：http://www.mysqlpub.com/forum.php?mod=viewthread&tid=1059&extra=page%3D1
目录：
MySQL Stored Procedure Programming
Advance Praise for MySQL Stored Procedure Programming
Preface
Objectives of This Book
Structure of This Book
What This Book Does Not Cover
Conventions Used in This Book
Which Version?
Resources Available at the Book's Web Site
Using Code Examples
Safari® Enabled
How to Contact Us
Acknowledgments
Part I: Stored Programming Fundamentals
Chapter 1. Introduction to MySQL Stored Programs
Section 1.1. What Is a Stored Program?
Section 1.2. A Quick Tour
Section 1.3. Resources for Developers Using Stored Programs
Section 1.4. Some Words of Advice for Developers
Section 1.5. Conclusion
Chapter 2. MySQL Stored Programming Tutorial
Section 2.1. What You Will Need
Section 2.2. Our First Stored Procedure
Section 2.3. Variables
Section 2.4. Parameters
Section 2.5. Conditional Execution
Section 2.6. Loops
Section 2.7. Dealing with Errors
Section 2.8. Interacting with the Database
Section 2.9. Calling Stored Programs from Stored Programs
Section 2.10. Putting It All Together
Section 2.11. Stored Functions
Section 2.12. Triggers
Section 2.13. Calling a Stored Procedure from PHP
Section 2.14. Conclusion
Chapter 3. Language Fundamentals
Section 3.1. Variables, Literals, Parameters, and Comments
Section 3.2. Operators
Section 3.3. Expressions
Section 3.4. Built-in Functions
Section 3.5. Data Types
Section 3.6. MySQL 5 "Strict" Mode
Section 3.7. Conclusion
Chapter 4. Blocks, Conditional Statements, and Iterative Programming
Section 4.1. Block Structure of Stored Programs
Section 4.2. Conditional Control
Section 4.3. Iterative Processing with Loops
Section 4.4. Conclusion
Chapter 5. Using SQL in Stored Programming
Section 5.1. Using Non-SELECT SQL in Stored Programs
Section 5.2. Using SELECT Statements with an INTO Clause
Section 5.3. Creating and Using Cursors
Section 5.4. Using Unbounded SELECT Statements
Section 5.5. Performing Dynamic SQL with Prepared Statements
Section 5.6. Handling SQL Errors: A Preview
Section 5.7. Conclusion
Chapter 6. Error Handling
Section 6.1. Introduction to Error Handling
Section 6.2. Condition Handlers
Section 6.3. Named Conditions
Section 6.4. Missing SQL:2003 Features
Section 6.5. Putting It All Together
Section 6.6. Handling Stored Program Errors in the Calling Application
Section 6.7. Conclusion
Part II: Stored Program Construction
Chapter 7. Creating and Maintaining Stored Programs
Section 7.1. Creating Stored Programs
Section 7.2. Editing an Existing Stored Program
Section 7.3. SQL Statements for Managing Stored Programs
Section 7.4. Getting Information About Stored Programs
Section 7.5. Conclusion
Chapter 8. Transaction Management
Section 8.1. Transactional Support in MySQL
Section 8.2. Defining a Transaction
Section 8.3. Working with Savepoints
Section 8.4. Transactions and Locks
Section 8.5. Transaction Design Guidelines
Section 8.6. Conclusion
Chapter 9. MySQL Built-in Functions
Section 9.1. String Functions
Section 9.2. Numeric Functions
Section 9.3. Date and Time Functions
Section 9.4. Other Functions
Section 9.5. Conclusion
Chapter 10. Stored Functions
Section 10.1. Creating Stored Functions
Section 10.2. SQL Statements in Stored Functions
Section 10.3. Calling Stored Functions
Section 10.4. Using Stored Functions in SQL
Section 10.5. Conclusion
Chapter 11. Triggers
Section 11.1. Creating Triggers
Section 11.2. Using Triggers
Section 11.3. Trigger Overhead
Section 11.4. Conclusion
Part III: Using MySQL Stored Programs in Applications
Chapter 12. Using MySQL Stored Programs in Applications
Section 12.1. The Pros and Cons of Stored Programs in Modern Applications
Section 12.2. Advantages of Stored Programs
Section 12.3. Disadvantages of Stored Programs
Section 12.4. Calling Stored Programs from Application Code
Section 12.5. Conclusion
Chapter 13. Using MySQL Stored Programs with PHP
Section 13.1. Options for Using MySQL with PHP
Section 13.2. Using PHP with the mysqli Extension
Section 13.3. Using MySQL with PHP Data Objects
Section 13.4. Conclusion
Chapter 14. Using MySQL Stored Programs with Java
Section 14.1. Review of JDBC Basics
Section 14.2. Using Stored Programs in JDBC
Section 14.3. Stored Programs and J2EE Applications
Section 14.4. Using Stored Procedures with Hibernate
Section 14.5. Using Stored Procedures with Spring
Section 14.6. Conclusion
Chapter 15. Using MySQL Stored Programs with Perl
Section 15.1. Review of Perl DBD::mysql Basics
Section 15.2. Executing Stored Programs with DBD::mysql
Section 15.3. Conclusion
Chapter 16. Using MySQL Stored Programs with Python
Section 16.1. Installing the MySQLdb Extension
Section 16.2. MySQLdb Basics
Section 16.3. Using Stored Programs with MySQLdb
Section 16.4. A Complete Example
Section 16.5. Conclusion
Chapter 17. Using MySQL Stored Programs with .NET
Section 17.1. Review of ADO.NET Basics
Section 17.2. Using Stored Programs in ADO.NET
Section 17.3. Using Stored Programs in ASP.NET
Section 17.4. Conclusion
Part IV: Optimizing Stored Programs
Chapter 18. Stored Program Security
Section 18.1. Permissions Required for Stored Programs
Section 18.2. Execution Mode Options for Stored Programs
Section 18.3. Stored Programs and Code Injection
Section 18.4. Conclusion
Chapter 19. Tuning Stored Programs and Their SQL
Section 19.1. Why SQL Tuning Is So Important
Section 19.2. How MySQL Processes SQL
Section 19.3. SQL Tuning Statements and Practices
Section 19.4. About the Upcoming Examples
Section 19.5. Conclusion
Chapter 20. Basic SQL Tuning
Section 20.1. Tuning Table Access
Section 20.2. Tuning Joins
Section 20.3. Conclusion
Chapter 21. Advanced SQL Tuning
Section 21.1. Tuning Subqueries
Section 21.2. Tuning "Anti-Joins" Using Subqueries
Section 21.3. Tuning Subqueries in the FROM Clause
Section 21.4. Tuning ORDER and GROUP BY
Section 21.5. Tuning DML (INSERT, UPDATE, DELETE)
Section 21.6. Conclusion
Chapter 22. Optimizing Stored Program Code
Section 22.1. Performance Characteristics of Stored Programs
Section 22.2. How Fast Is the Stored Program Language?
Section 22.3. Reducing Network Traffic with Stored Programs
Section 22.4. Stored Programs as an Alternative to Expensive SQL
Section 22.5. Optimizing Loops
Section 22.6. IF and CASE Statements
Section 22.7. Recursion
Section 22.8. Cursors
Section 22.9. Trigger Overhead
Section 22.10. Conclusion
Chapter 23. Best Practices in MySQL Stored Program Development
Section 23.1. The Development Process
Section 23.2. Coding Style and Conventions
Section 23.3. Variables
Section 23.4. Conditional Logic
Section 23.5. Loop Processing
Section 23.6. Exception Handling
Section 23.7. SQL in Stored Programs
Section 23.8. Dynamic SQL
Section 23.9. Program Construction
Section 23.10. Performance
Section 23.11. Conclusion |
|
|Archiver|小黑屋|手机版|MariaDB社区
( 京ICP备07012489号 ) 
|
IP卡
狗仔卡
发表于 2009-3-18 10:23:07
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
转播
分享
淘帖
顶
踩
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2009-3-19 16:42:26
