MySql 中文参考指南

Chapter 27 Stored Objects

目录

Table of Contents

本章讨论存储在数据库中的对象，这些对象根据存储在服务器中以备以后执行的 SQL 代码来定义。

This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution.

存储对象包括以下对象类型：

Stored objects include these object types:

  1. Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. A procedure does not have a return value but can modify its parameters for later inspection by the caller. It can also generate result sets to be returned to the client program.

  2. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. You invoke it in an expression and it returns a value during expression evaluation.

  3. Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update.

  4. Event: An object created with CREATE EVENT and invoked by the server according to schedule.

  5. View: An object created with CREATE VIEW that when referenced produces a result set. A view acts as a virtual table.

本文档中使用的术语反映了存储对象层次结构：

Terminology used in this document reflects the stored object hierarchy:

  1. Stored routines include stored procedures and functions.

  2. Stored programs include stored routines, triggers, and events.

  3. Stored objects include stored programs and views.

本章节介绍如何使用存储对象。以下部分提供了与这些对象相关的语句的 SQL 语法以及对象处理的其他信息：

This chapter describes how to use stored objects. The following sections provide additional information about SQL syntax for statements related to these objects, and about object processing:

  1. For each object type, there are CREATE, ALTER, and DROP statements that control which objects exist and how they are defined. See Section 15.1, “Data Definition Statements”.

  2. The CALL statement is used to invoke stored procedures. See Section 15.2.1, “CALL Statement”.

  3. Stored program definitions include a body that may use compound statements, loops, conditionals, and declared variables. See Section 15.6, “Compound Statement Syntax”.

  4. Metadata changes to objects referred to by stored programs are detected and cause automatic reparsing of the affected statements when the program is next executed. For more information, see Section 10.10.3, “Caching of Prepared Statements and Stored Programs”.