To use this database, we need to insert some data into the table.
要使用这个数据库,我们需要向表中插入一些数据。
For every resource, insert one row into this table.
对于每个资源,在这个表中插入一行。
Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.
因为审核日志表格里有大量的数据,单独的insert语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
INSERT adds the input data to the table without changing any existing data.
INSERT将输入数据添加到表中,并且不更改任何现有数据。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
INSERT mode adds the input data to the table without changing any existing data.
INSERT模式添加输入数据到表中,并且不会更改任何现有数据。
The DB2 transaction associated with an upload included generating a unique document ID, logging the upload in the activity history table, and executing a SQL INSERT into 18 tables.
与上传相关联的DB2事务包括生成惟一的文档id、在活动历史表中记录这次上传以及对18个表执行SQLINSERT。
To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.
为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATETABLE和INSERT语句定义示例表和数据。
Performing a SELECT statement on the table fetches the messages in the queue, and and doing an INSERT statement on the table sends the message.
在表上执行一条select语句就可以取得队列中的消息,而执行表上的insert语句就可以发送消息。
Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.
由于INSERT和select语句之间没有COMMIT,死锁可能是由表扫描引起的。
You can see from the form of the INSERT INTO in Listing 5 that a table had been created to correspond with the element in our DTD.
可以从清单5中INSERT INTO的形式看出,对应dtd中的元素创建了一个表。
Use Load and a staging table or a multithreaded application to achieve Insert parallelism.
使用Load和staging表或多线程应用程序,以实现Insert的并行性。
Add data to the table using SQL INSERT statements.
使用SQLinsert语句将数据添加到表中。
To load data from the data file /data/americascust.dat (created above) into the base table customer, use the INSERT statement as follows
要将数据文件 /data/americascust.dat(此前已创建)中的数据加载到基表customer,可以使用INSERT 语句(如下所示)
If you have modified the Users table schema, be sure to make the matching changes to the Insert statement.
如果已经修改了users表的模式,那么一定要对insert语句进行相应的修改。
Drag the BOOKSTORE table onto the pane to create a new INSERT statement.
将BOOKSTORE表拖到窗格上以创建一个新的insert语句。
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能够确保索引始终与表数据一致。
You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.
现在可以在一个表上定义多个INSERT、DELETE、UPDATE和SELECT触发器,也可以在一个视图上定义多个INSTEADOF 触发器。
When DB2 encounters an INSERT on an MDC table, it looks for a free block.
当DB 2碰到对mdc表的INSERT操作时,它寻找一个空闲的块。
In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.
在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。
When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.
当一个指定的SQL操作(如DELETE,INSERT,或者是UPDATE操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
The script starts by connecting to the database. It then executes an INSERT statement against the games table and gets back the ID that was generated.
此脚本从连接数据库开始,然后对games表执行一条insert语句,并获取生成的ID。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。
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)隔离级别)。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
Upon arrival, a customer-written program adds the records to a staging table then USES insert statements to add the records to the fact table.
当该文件到来时,用户编写的一个程序将这些记录添加到一个staging表中,然后使用insert语句将这些记录添加到事实表中。
Since this is a table operation, tooling generates insert, update, and delete operations automatically.
由于这是一项表操作,因此工具将自动生成insert、update和delete操作。
After you create the table, you use one insert statement for each entry in your toppings array.
创建表后,需要对浇头数组中的每个条目使用一条insert语句。
The use of a staging table can provide improved performance for some insert scenarios.
通过使用staging表可以为某些场景下的insert提高性能。
And follow up with populating the DEPARTMENT table with the data delineated in table 2 with an INSERT command such as.
再通过如下insert命令用表2给出的数据填充DEPARTMENT填充。
应用推荐