For every row that moves, there are two actions - insert and delete.
对于所移动的每一行,有两个动作—insert和delete。
Notice the use of the index function within the at attribute of the insert and delete actions.
请注意insert和delete动作的at属性内index函数的使用。
In real life, you would rarely want to drop an existing database but merely INSERT and DELETE from tables.
在现实生活中,您不太会drop现有的数据库,而只是从表中INSERT和DELETE。
The old version of the redistribute utility USES special insert and delete with sub-select statements.
旧版本的重分发实用程序通过子选择语句使用特殊的insert和delete。
We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new index's query speed-up benefit.
我发现有一个聚合索引成本的点 —例如,更为昂贵的INSERT和DELETE操作 —超出一个新索引的查询加速所能带来的效益。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQLupdate语句是SQLINSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
Administrators have the privilege to manage the background of the system. They can insert and delete the users, classify the food information, check the order forms and manage the total number.
管理员对后台进行管理,可以添加和删除管理员,对餐饮信息进行分类,查看订单和积分管理等。
This feature enables you to batch multiple INSERT, UPDATE, and DELETE requests even when they reference multiple tables.
这个特性允许您对多个INSERT、UPDATE和DELETE请求进行批处理,即使它们引用多个表。
Heterogeneous batching can potentially improve the performance on INSERT, UPDATE and DELETE statements that operate on multiple tables.
异构批处理能够潜在地提高在多个表上对语句进行INSERT、UPDATE和DELETE操作时的性能。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
You can also perform INSERT, UPDATE, and DELETE operations for relational nicknames, but not for non-relational nicknames.
对于关系昵称,也可以执行INSERT、UPDATE和DELETE操作,但是对于非关系昵称不可以执行这些操作。
In addition to the INSERT examples provided here, you can also issue UPDATE and DELETE statements against relational nicknames just as if they were local tables.
除了这里提供的INSERT例子外,还可以对关系昵称发出UPDATE和delete语句,就像它们是本地表一样。
After the execution of the UPDATE, INSERT, and DELETE statements, an additional variable is available to check the result of the statement.
执行完update、INSERT和delete语句后,将使用额外的一个变量来检查语句的结果。
Given the number of INSERT, UPDATE, and DELETE operations and changes in data distributions, you need to collect the right statistics regularly and with minimum resource consumption.
您需要根据INSERT、UPDATE和DELETE操作的数目和数据分布的变化,在资源消耗尽量少的情况下定期收集正确的统计数据。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
In addition, triggers can now contain UPDATE, DELETE, and INSERT operations together in a single clause as the trigger event. For example.
另外,触发器现在可以在单一子句中同时包含UPDATE、DELETE和INSERT操作,作为一个触发器事件。
Now you can add images to the Delete Row and Insert Row buttons to make them look more attractive.
现在,可以向DeleteRow和Insert Row按钮添加图像以使它们看起来更有吸引力。
The DBMS ensures that the index is always consistent with the data in the table by updating it during INSERT, UPDATE, and DELETE operations.
通过使用INSERT、UPDATE和DELETE操作对索引进行更新,DBMS能够确保索引始终与表数据一致。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE ( 数据更改操作)放入到关联连接的内表中。
At 15,000 R6Mail users, the DB2 server is executing an average of 160,000 SQL statements per minute, including the SELECT, INSERT, DELETE, and UPDATE statements.
有15,000个R 6 Mail用户时,DB 2服务器平均每分钟执行160,000个sql语句,其中包括SELECT、INSERT、DELETE和update语句。
Also, BEFORE triggers can now contain UPDATE, DELETE, INSERT and routines that modify data.
另外,BEFORE触发器现在可以包含UPDATE、DELETE、INSERT和修改数据的例程。
Online backups can run during normal SELECT, INSERT, DELETE, and UPDATE activity against the database.
在对数据库进行常规的SELECT、INSERT、DELETE和UPDATE活动的同时可以执行在线备份。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax.
但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的 SQL语法操作第三方服务上的数据。
This is because heterogeneous batching in the current release of the Integration Module only improves performance of INSERT, UPDATE, and DELETE statements.
这是因为当前版本的IntegrationModule中的异构批处理仅提高INSERT、UPDATE和delete语句的性能。
Many factors affect performance during SELECT, INSERT, UPDATE, and DELETE operations. These include.
在执行SELECT、INSERT、UPDATE和DELETE操作时,很多因素都会对性能产生影响。
This clause allows an SQL Table function to contain UPDATE, DELETE, INSERT and MERGE statements.
这个子句允许sql表函数包含UPDATE、DELETE、INSERT和merge语句。
The JDBC data mediator service generates the appropriate SQL statements (SELECT, INSERT, UPDATE, and DELETE) to access the target data source.
JDBC数据中介服务生成适当的sql语句(SELECT、INSERT、UPDATE和DELETE)来访问目标数据源。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
Ability to execute standard SQL statements such as SELECT, INSERT, UPDATE, and DELETE, combinations of these statements, user-defined SQL, as well as bulk load.
能够执行SELECT、INSERT、UPDATE和DELETE等sql语句和sql语句组合、用户定义的sql语句以及整体加载语句。
All that DB2 does is to allow an UPDATE, DELETE, and INSERT to appear in the from clause of a select and allow the user to chose which transition table shall be selected from.
DB 2所做的就是允许UPDATE、DELETE和INSERT出现在选择语句的from子句中,并允许用户选择应该从哪个过渡表进行选择。
应用推荐