因此,修改表中的所有行(文档)。
修改表空间信息以适应您的测试环境。
Modify the tablespace information to fit your test environment. Say, for example, in production you have the following tablespace.
在这里,可以用编辑器修改表中的任何字段。
From here you can change any fields in the table that you want in the editor that becomes available.
这些查询在处理期间“临时”转换文档,并不修改表中的文档。
These queries transform the document "on the fly" during query processing and do not change the document in the table.
然后使用SQLupdate语句来修改表中选定行的列值。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
DB2 9.7新增的两项重要增强均与在线修改表定义相关
There are two significant enhancements in DB2 9.7 related to online modifications to the table definition
下一个示例演示了如何不仅为表数据,还为索引和lob修改表空间。
The next example demonstrates how to alter the tablespace not only for table data, but also for indexes and LOBs.
如何使用ADMIN_MOVE_TABLE例程移动表和修改表属性?
How to use ADMIN_MOVE_TABLE routing to move tables and modify table properties?
尤其是,对于范围分区表,仍然可以使用以前支持的创建和修改表的sql语句。
In particular, the previously supported SQL statements for creating and altering tables for range partitioning as well as attaching and detaching partitions still apply.
如果没有包括where子句,则update语句将修改表中所有行的指定列。
If the WHERE clause isn't included, the UPDATE statement modifies the indicated columns for all rows in the table.
要想调整此方法以支持全局重置,只需修改表创建语句,让它们创建常规表而不是CGTT。
To adapt the method to support global reset, simply change the table creation statements to create regular tables rather than CGTTs.
可以在不停机的情况下修改表(甚至修改列的类型),还可以在表空间之间转移表。
Changing tables — even changing column type — can be done with no downtime, as can moving a table from one table space to another.
可以添加和删除索引;通过删除、改名或添加列来修改表;甚至在必要的时候借助于SQL。
You can add and drop indexes; alter tables by dropping, renaming, or adding columns; and even drop down into SQL as necessary.
数据保护,包括添加安全策略,可以在创建表时进行,也可以在创建表之后通过修改表来实现。
Data protection, including adding a security policy, can be done when creating the table or later by altering the table.
下面的例子展示了如何创建或修改表空间,以便使用NO FILE SYSTEM CACHING选项。
The following example shows how to create or alter a tablespace to use this option.
production模式的默认值 —update — 会在重新启动之间保持所有数据,也会在需要的时候创建或修改表。
The default value for production mode — update — keeps all data around between restarts, as well creating or altering tables as necessary.
这也就是说在不修改任何表信息情况下就可以修改模式的用法。
This means that modifications to schema usage can be made without modifying any table information.
如果已经修改了users表的模式,那么一定要对insert语句进行相应的修改。
If you have modified the Users table schema, be sure to make the matching changes to the Insert statement.
这个样式表修改的示例是非常简单的,但是它应该能使您对如何做出此类修改有一个大致的了解。
This style sheet modification example is a very simple one, but this should give you an idea of how to make such changes.
函数 setmetatable()和getmetatable() 分别对对象的元表进行修改和查询。
The functions setmetatable() and getmetatable() modify and query an object's metatable, respectively.
如果图像太大或太小,您可以在样式表中对其进行修改。
If the image is too big or too small, you can change it in the stylesheet.
例如,您可能需要浏览数据库,修改或删除表,执行扩展修改,在现有的表中添加列。
For example, you can browse your database for tables that need to be modified or dropped, perform extended alters, and add columns to an existing table.
允许在复制的表上进行修改操作。
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
可以使用 ADMIN_MOVE_TABLE 例程在线修改和移动表。
Tables can be changed and moved online using the ADMIN_MOVE_TABLE routine.
表1 .memcached修改命令参数。
STATCHANGE是指系统中所有表的修改阈值,采用百分比形式。
STATCHANGE is the percentage change threshold value for all tables in your system.
表3给出修改任务和设置新任务所需的参数。
Table 3 shows the parameters needed to modify and set up new tasks.
如果创建新的索引,而在最后一次执行RUNSTATS以后还未修改相应的表,那么您可以只收集索引上的目录统计信息。
If new indexes have been created, and the corresponding table has not been modified since the last RUNSTATS execution, then you can collect catalog statistics on indexes only.
创建、浏览以及修改对象(表、视图、索引等),这其中包括Oracle8 TYPE对象。
Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE objects.
应用推荐