MySql Stored Procedure

kevin011279

    MySql Stored Procedure is supported by MySql5.0 or later. It is similar to IBM's DB2 implementation, as both are based on SQL：2003 standard.

• Merits(why)

Stored procedure can run in all environments, since they are on the database server.It makes no difference what application environment is used.

Stored procedure can reduce network traffic,because complex repetative tasks can be done on database server.

Stored procedure makes programs shorter and clearer.

• Syntax(how)

    DELIMETER //
    CREATE PROCEDURE sp_name ()
    BEGIN
    DECLARE var type;
    statments;
    ...
    END //
    DELIMETER ;
More details:

       
        文件:MySqlProcedure.pdf
        大小:2170KB
        下载:
下载
       


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/60890/showart_1095676.html