|
0
发表于: 2009-03-29 14:01
0
大家使用 Procedure 多吗？不知道大家在使用 MySQL 数据库的时候有没有使用 Procedure 功能？
选择使用 Procedure 的时候主要是基于一种什么考虑？ |
|
|---|---|
|
2
发表于: 2009-06-16 14:59
怎么可能呢，兄弟.....mysql早期版本4.1.7之前的版本不支持，后面都支持
|
|
|---|---|
|
3
发表于: 2009-06-25 11:49
摘文档：
Some situations where stored routines can be particularly useful: When multiple client applications are written in different languages or work on different platforms, but need to perform the same database operations. When security is paramount. Banks ,for example ,use stored procedures and functions for all commonoperations. This provides a consistent and secure environment, and routines can ensure that each operation is properly logged.In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. MySQL触发器，应该也可以做审计用吧  |
|
|---|---|
|
4
发表于: 2009-07-09 11:06
和其他的数据库一样，用到proc的应该是需要进行游标处理，复杂数据逻辑运算等场景
|
|
|---|---|
