If you hold CONTROL privilege on a table, you can update values that pertain to that table, but if you hold explicit DBADM authority on the database, you can change any updatable column.
如果在某个表上拥有CONTROL权限,那么就可以更新属于该表的值,但是如果拥有数据库上显式的DBADM授权的话,那么您可以更新任何可更新的列。
The database server automatically issues the prepare statement to update any prepared objects that reference the table.
数据库服务器自动发出PREPARE命令,更新引用该表的任何编译过的对象。
If a row has already been updated or deleted, then this row cannot be joined again with any source table row for another update or delete again.
如果一个行已被更新或者删除,那么不能针对该行再次更新与删除,再次与任何源表联接。
Read-only tables: If there is never any update activity on a table, then it can be defined with no free space.
只读表:如果对于一个表没有任务更新活动,那么可以将其定义为没有空余空间。
Is it better to create stored procedures for any required operations on a table in the database (e. g. create and read on this table, update and delete only on another one,...)?
这是更好地创建所需的任何操作在一个数据库中的表的存储过程(例如创建和读取此表,更新和删除只有一个,……)?
For example, you must update any stored procedures that reference a table column that you have renamed.
例如,如果重命名表中的一列,则必须更新引用该列的所有存储过程。
If any part of the update for any table fails, the whole transaction is rolled back.
如果任何资料表的任何部分更新失败,则整个交易就会复原。
If any part of the update for any table fails, the whole transaction is rolled back.
如果任何资料表的任何部分更新失败,则整个交易就会复原。
应用推荐