INSERT_UPDATE adds new input data to the table, or updates existing rows with input data that has matching primary key values.
INSERT_UPDATE将新的输入数据添加到表中,或者用具有匹配主键值的输入数据更新现有的行。
The best practice is to have many columns in a row, as opposed to linking different rows across different tables via key columns.
相对于通过键列跨不同的表链接不同行,最佳实践将是在一行中有许多列。
As with earlier releases of DB2, it is important to select a distribution key that evenly distributes rows across partitions.
与以前的DB 2版本一样,一定要通过选择分布键跨分区均匀地分布行。
Similarly, relational database rows are also unique, so long as they are identified by primary key values.
同样,关系数据库中的行也是惟一的,它们由主键值标识。
In fact, the use of an index for sort avoidance is a key way to improve the performance of SQL that qualifies far more rows than will actually ever be FETCHed.
事实上,使用一个索引来避免排序的一个关键方法是提高SQL性能,使其比应用FETCH实际获取的行更多。
The B-tree would store the key value, followed by a list of pointers to each of the physical rows.
B-树将存储键值,以及一个指向每个物理行的指针列表。
Recall that clients were defined with a primary key on the client ID column, so attempting to import duplicate rows will fail.
记得clients对客户ID列定义了一个主键,因此在尝试导入相同行时将失败。
Use the Index or primary key field to select the key columns that the Q Apply program uses to identify replicated rows and correctly order transactions.
使用Indexorprimarykey字段来选择键列,QApply程序用以识别复制的行以及正确命令事务。
Distributing both tables by hashing on their join key (pdb_id) also ensures that all atom rows for a given PDBML document are stored in the same database partition as the PDBML document itself.
通过对上述两个表的连接键(pdb_id)进行散列处理来分布两个表也能确保给定pdbml文档中所有原子行均能作为本身的PDBML文档存储在相同的数据库分区中。
One bouquiniste near Notre Dame presided over a stall with only a handful of books, but rows of paintings of Eiffel towers, key-rings, ashtrays and even house number plaques and "dangerous dog" signs.
巴黎圣母院旁边的一个书摊,摊位上只摆了一小摞书,其余是成排成排的埃菲尔铁塔画、钥匙扣、烟缸、甚至还有门牌号码板和写着“有狗危险”的标示牌。
However, DB2 replication requires a key or index to uniquely identify rows in a table.
然而,DB 2复制要求使用一个主键或惟一索引来区分一个表中的记录。
The key is that the SQL statement in the prepared statement references the current position of the cursor, so you can execute it multiple times and update different rows.
关键是准备好的语句中的sql语句会引用游标的当前位置,所以您可以多次执行它,并更新不同的行。
This is a key that combines a number of columns to uniquely define the rows of a database table.
这个键组合了多列,唯一地定义一个数据库表的行。
Each row of a table is uniquely identified by a primary key composed of one or more columns. This implies that a table may not contain duplicate rows.
表的每一行都是由一个唯一的主键标识的。主键由一列或多列构成。这意味表里不会有重复的行。
The smallest table is scanned first, and the hash table is populated with Pointers to the rows that match each key.
最小的表首先被扫描,然后哈希表被填入相匹配的每个键的行指针。
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
未能启用约束。一行或多行中包含违反非空、唯一或外键约束的值。
Why does DROP PRIMARY KEY affects ALL table rows?
为什么删除主键会影响所有的表行吗?
For example, if you created an INT field for your primary key, however do not have too many rows, it might suggest you to use a MEDIUMINT instead.
比如,如果你建了一个INT型来作为主键,然而你并没有太多的行,他将会建议你使用MEDIUMINT。
Because each row has a unique primary key, no two rows share the same key value.
由于每一行都具有唯一的主键,因此任何两行都不会共用同一键值。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
Gets the name, row size, number of rows, number of columns, and key column index of the specified table.
取得指定之资料表的名称、资料列大小、资料列数目、资料行数目和索引键资料行索引。
If the line appears solid, the DBMS enforces referential integrity for the relationship when rows are added or modified in the foreign-key table.
如果为实线,则当在外键表中添加或修改行时,DBMS将强制关系的引用完整性。
If the line appears dotted, the DBMS does not enforce referential integrity for the relationship when rows are added or modified in the foreign-key table.
如果为点线,则当在外键表中添加或修改行时,DBMS不强制关系的引用完整性。
If the line appears dotted, the DBMS does not enforce referential integrity for the relationship when rows are added or modified in the foreign-key table.
如果为点线,则当在外键表中添加或修改行时,DBMS不强制关系的引用完整性。
应用推荐