因此,修改表中的所有行(文档)。
在这里,可以用编辑器修改表中的任何字段。
From here you can change any fields in the table that you want in the editor that becomes available.
修改表空间信息以适应您的测试环境。
Modify the tablespace information to fit your test environment. Say, for example, in production you have the following tablespace.
这些查询在处理期间“临时”转换文档,并不修改表中的文档。
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
使用数据库关系图可以创建和修改表、列、关系和键。
Using database diagrams you can create and modify tables, columns, relationships, and keys.
下一个示例演示了如何不仅为表数据,还为索引和lob修改表空间。
The next example demonstrates how to alter the tablespace not only for table data, but also for indexes and LOBs.
如果不需要修改表的结构,则需要使用临时表,如清单6所示。
If you do need to modify the structure of a table, you need to use a temporary table, as shown in Listing 6.
如何使用ADMIN_MOVE_TABLE例程移动表和修改表属性?
How to use ADMIN_MOVE_TABLE routing to move tables and modify table properties?
还可以修改表的大小(每个页面上的条目数量)和数据刷新频率以满足自己的需要。
The size of the table (number of entries per page) and data refresh rates can also be changed to meet the your needs.
主要包括实现查看库表结构情况、修改表结构功能的设计思想和实现方法。
The main function includes the query of tables structure and the modification of structure tables.
我们不会把这种痛苦带到坟墓中,相反,我们将针对照片修改表设计,如清单2 所示
Rather than carrying unhappiness to the grave, we'll modify our table design for images, as shown in Listing 2
尤其是,对于范围分区表,仍然可以使用以前支持的创建和修改表的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.
单击configureportlet图标configure图标并修改表4所示的参数。
Click the Configure portlet icon and change the parameters listed in table 4.
可以添加和删除索引;通过删除、改名或添加列来修改表;甚至在必要的时候借助于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.
虽然这个特例的后果可能并不太严重,但完全有可能添加更恶意的代码,尤其是会修改表的DELETE或update语句。
While this particular example might not be considered severe, other more malicious code could be added, especially DELETE or UPDATE statements that modify tables.
production模式的默认值 —update — 会在重新启动之间保持所有数据,也会在需要的时候创建或修改表。
The default value for production mode — update — keeps all data around between restarts, as well creating or altering tables as necessary.
如本例所示,要修改表,在本例中是将一个新列count添加到bigdog. products表中,首先要创建一个具有需要的正确模式的表。
As this example shows, to modify a table — in this case, to add a new count column to the bigdog.products.
看看你能否修改你的时间表,想出切实可行的方法来减少你待命的时间。
See if you can rework your schedule and come up with practical ways to reduce the number of hours you're on call.
这也就是说在不修改任何表信息情况下就可以修改模式的用法。
This means that modifications to schema usage can be made without modifying any table information.
允许在复制的表上进行修改操作。
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
例如,您可能需要浏览数据库,修改或删除表,执行扩展修改,在现有的表中添加列。
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.
上例演示了如何修改单个表中特定行的多个列值。
The previous example demonstrated how to modify multiple column values for a specific row in a single table.
应用推荐