phpMyAdmin存储过程说明 [英] phpMyAdmin Stored Procedure Explanation

问题描述

在phpMyAdmin中创建存储过程时，我发现以下选项屏幕.

I have found the following option screen when creating a Stored Procedure in phpMyAdmin.

现在我不知道一切意味着什么.

Now I wonder what everything means.

我知道Routine name，Type，Parameters，Definition，Definer，Security type和Comment选项.

I know the Routine name, Type, Parameters, Definition, Definer, Security type and Comment options.

但是我不知道如何处理Is deterministic和SQL data access.我曾尝试用Google搜索它，但找不到它.有人可以启发我这些价值观的含义吗?

I however do not know what to do with Is deterministic and SQL data access. I have tried to Google it, but couldn't find it. Can someone enlighten me what those values mean?

推荐答案

确定性:

如果过程或函数对于相同的输入参数始终产生相同的结果，则将其视为确定性"，否则将其视为不确定性".如果例程定义中既未提供DETERMINISTIC，也未提供NOT DETERMINISTIC，则默认值为NOT DETERMINISTIC.

A procedure or function is considered "deterministic" if it always produces the same result for the same input parameters, and "not deterministic" otherwise. If neither DETERMINISTIC nor NOT DETERMINISTIC is given in the routine definition, the default is NOT DETERMINISTIC.

SQL数据访问:

• CONTAINS SQL表示该例程不包含读取或写入数据的语句.如果未明确给出这些特征，则为默认设置.此类语句的示例为SET @x = 1或DO RELEASE_LOCK('abc')，它们执行但既不读取也不写入数据.

• CONTAINS SQL indicates that the routine does not contain statements that read or write data. This is the default if none of these characteristics is given explicitly. Examples of such statements are SET @x = 1 or DO RELEASE_LOCK('abc'), which execute but neither read nor write data.

否SQL表示例程不包含SQL语句.

NO SQL indicates that the routine contains no SQL statements.

READS SQL DATA表示例程包含读取数据的语句(例如SELECT)，但不包含写入数据的语句.

READS SQL DATA indicates that the routine contains statements that read data (for example, SELECT), but not statements that write data.

MODIFIES SQL DATA指示该例程包含可能写入数据的语句(例如INSERT或DELETE).

MODIFIES SQL DATA indicates that the routine contains statements that may write data (for example, INSERT or DELETE).

这篇关于phpMyAdmin存储过程说明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！