tailieunhanh - MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series – Part 1

Oracle8i introduced the use of Java as a procedural language with a Java Virtual Machine (JVM) in the database (originally called JServer). JVM includes support for Java stored procedures, methods, triggers, Enterprise JavaBeans™ (EJBs), CORBA, and HTTP. The Accelerator is used for project generation, translation, and compila- tion, and can also be used to deploy/install shared libraries. The inclusion of Java within the Oracle database allows Java developers to leverage their skills as Oracle application developers. Java applications can be deployed in the client, Application Server, or database, depending on what is most appropriate. We discuss Java development in Chapters 13 and 14. Oracle data warehousing options for OLAP. | MySQL Stored Procedures MySQL New Features Series - Part 1 A MySQL Technical White Paper Peter Gulutzan March 2005 Copyright 2005 MySQL AB Table of Contents A Definition and an Why Stored Why MySQL Statements are Legal in a Procedure Characteristics The New SQL Error Tips when writing long Feature About Copyright 2005 MySQL AB Page 2 Introduction This book is for long-time MySQL users who want to know what s new in version 5. The short answer is stored procedures triggers views information_schema . The long answer is the MySQL New Features series and this book is the first in the series. What I m hoping to do is make this look like a hands-on session where you as if you re working it out yourself on your keyboard can walk through sample problems. To do this I ll go through each little item building up slowly. By the end I ll be showing larger routines that do something useful something that you might have thought was tough. Conventions and Styles Whenever I want to show actual code such as something that comes directly from the screen of my mysql client program I switch to a Courier font which looks different from the regular text font. For example mysql DROP FUNCTION f Query OK 0 rows affected sec When the example is large and I want to draw attention to a particular line or phrase I highlight it with a double underline and a small arrow on the right of the page. For example mysql CREATE PROCEDURE p - BEGIN - This procedure does nothing -- - END Query OK 0 rows affected sec Sometimes I will leave out the mysql and - prompts so that you can cut the examples and paste them into your copy of the mysql client program. If you aren t reading the text of this book in a machine-readable form try looking .