标签中的table属性用来指明连接表。
创建一个连接表来管理这个关系会非常适合。
Creating a join table to manage this relationship would be the right thing to do.
连接次序指示,强制优化器按照指定次序连接表。
Join order directives that force optimizer to join tables in the designated order.
有时候,如果负载过重,连接会挂起,并且会占用连接表空间。
Sometimes, under load, connections hang around and take up connection table space.
flight是连接表,表示其他表之间的复杂关系。
The flight table is the join table, representing the complex relationship among the other tables. Listing 8 shows the fields in the flight table.
当连接表的连接列上没有可用索引时,通常使用该连接方法。
This join method is usually used when no index is available on the join columns for the joining tables.
这个步骤至少需要3个连接表(3个连接表中包含自连接)。
This step requires a minimum of 3 tables to be joined (where the 3 tables can include self-joins).
连接表允许将具有一个作者的图书和具有多个作者的图书持久化。
The join table allows you to persist books with a single author as well as books with multiple authors.
如果你想用一个一对多的关系,你应该使用一个连接表来代替。
If you want to use a one-to-many relationship you should use a join table instead.
本文简要地综述了基于连接表的手性中心和双键立体化学的描述方法。
The present paper reviews the methods used in connection table for the presentation of stereochemistry, particularly for the chiral carbons and double bonds.
同时文中还介绍了本系统使用的一种简便的紧缩连接表的结构存贮方法。
A simple compact structure storage method used in the system is also presented.
确实如此,Book和Author之间的关系已经超出了简单连接表的范围。
Indeed, the relationship between Book and Author goes beyond the simple join table.
因为该方法在进行表连接之前,必须将所有的连接表分类,所以其成本通常极其高。
Because this method has to sort all joining tables before they join, the costs are usually pretty high.
上图显示了在连接表实现中用相同数量的远程调用(即4 个)来检索整个购物车。
The figure shows that the same number of remote calls, namely four, is used to retrieve the entire shopping cart as in the joined-tables implementation.
您可以连接表1中显示的元素(以及其他操作符)并加以组合使用,从而构建(非常)复杂的正则表达式。
You can string together the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regular expressions.
<many-to-many>标签中的column属性用来指定连接表与目标类的映射表链接的外键。
The <many-to-many> tag's column attribute specifies the foreign key column in the link table that relates the link table to the mapping table for the target class.
当一个或多个连接表上没有索引时,或者当数据库服务器必须从所有连接表中读取大量行时,就使用这种方法。
It is used when there are no indexes on one or more joining tables, or when the database server must read a large number of rows from all joining tables.
supldata表由连接表中数据和TASK视图中任务数据的列构成,还有申明时安排任务次序所需的列。
The SUPLDATA table consists of columns needed to join the data in the table with the task data in the task view, as well as columns needed to order the tasks when they are claimed.
OrderItems表是多对多关系中Orders和Products的连接表,这样也不能代表对象模型中的一个实体。
The OrderItems table is a link table in a many-to-many relationship between Orders and Products. As such, it does not represent an entity from the business model.
用户也可以将XML文档和一个xslt样式表存储在不同的表中,而且可以通过连接表将单个xslt样式表应用到多个xml值。
Users can also store the XML documents and an XSLT stylesheet in separate tables and can apply a single XSLT stylesheet on multiple XML values by joining the tables.
在数据库中,用三个表表示m: m关系:前两个表您已经知道了(Book和Author),第三个是一个连接表(BookAuthor)。
In a database, three tables represent m: m relationships: the two tables you'd expect (Book and Author), and a third join table (BookAuthor).
如果该查询包含了连接,那么优化器就必须确定连接计划(hash、sortmerge或nestedloop),以及评估或连接表的次序。
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
GORM向BookAuthor 连接表添加 book_id和 author_id,而不是向Book或Author 表添加一个外键。
Rather than adding a foreign key to either the Book or Author table, GORM adds book_id and author_id to the BookAuthor join table.
这里您看到的是一个连接,内表在其中执行数据库修改。
What you see here is a join in which the inner performs database modifications.
检验连接并建立示例表和存储过程。
Verify connections and set up sample tables and stored procedures.
相关的输出包括网络连接、路由表、接口统计数据。
Relevant output includes network connections, routing tables, and interface statistics.
如果优化器首先连接两个表,那么连接结果可能十分庞大,并可能使用大量系统资源,如CPU和内存。
If the optimizer joins two tables first, the join results could be huge and may use a large amount of system resources such as CPU and memory.
然后,它将连接两个表。
需要按分区键进行连接的表应该有相同数量的分区,并且应该在相同的值上断开。
Tables that will be joined on the partitioning key should have the same number of partitions and should break on the same values.
需要按分区键进行连接的表应该有相同数量的分区,并且应该在相同的值上断开。
Tables that will be joined on the partitioning key should have the same number of partitions and should break on the same values.
应用推荐