mysql存储过程数据存取特征 contains sql/no sql/reads sql data/modifies sql data的区别
来源:互联网 发布:验证域名所有权 编辑:程序博客网 时间:2024/05/29 15:47
mysql创建存储过程的时候发现有这么四个数据存取限制的参数,网上查了好久从官网得到如下结果
一些特征提供子程序使用数据的内在信息。
CONTAINS SQL表示子程序不包含读或写数据的语句。
NO SQL表示子程序不包含SQL语句。
READS SQL DATA表示子程序包含读数据的语句,但不包含写数据的语句。
MODIFIES SQL DATA表示子程序包含写数据的语句。
如果这些特征没有明确给定,默认的是CONTAINS SQL。
自己创建存储过程后改变这些个参数,都不影响执行,也不影响创建,纳闷儿了,最后终于看到有个人说了这么一句话“这些特征值目前只提供给服务器,并没有根据这些特征值来约束过程实际的使用数据情况”,我不知道他说的对不对,反正我的是不受影响,继续观察中。
- mysql存储过程数据存取特征 contains sql/no sql/reads sql data/modifies sql data的区别
- Mysql创建Function出现This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA...
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its
- SQL Server 的数据存储(SQL Server data strorage)
- 错误码: 1418 This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- ERROR 1418 (HY000) at line 1323: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- 解决1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and b
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration a
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its de 错误解决办法
- Android4.0 battery架构和管理
- java 开发,进制数转化
- 被卡的英语
- 浅谈 XSS & CSRF
- 电池计量IC(MAX17040)
- mysql存储过程数据存取特征 contains sql/no sql/reads sql data/modifies sql data的区别
- Axis2 Web服务配置文件services.xml详解
- android安装PK到 /system/app/
- Android 内存剖析 – 发现潜在问题
- 10112 - Myacm Triangles
- yafeilinux.com的开源项目非常好的东西
- 电池充电IC(PM2301)
- DBF文件研究
- jQuery图片热点链接添加编辑插件