To use this database, we need to insert some data into the table.
要使用这个数据库,我们需要向表中插入一些数据。
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 语句(如下所示)
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 ( 数据更改操作)放入到关联连接的内表中。
Using the DB2 import command, we then populate this new table with data contained in the large del file: import from staffdata.del of del modified by chardel coldel, decpt. insert into newstaff.
然后我们使用DB 2import命令,用大型del文件中包含的数据填充这个新表:importfrom staffdata . del of del modifiedby chardel “ ” coldel, decpt . insert into newstaff。
Using the DB2 import command, we then populate this new table with data contained in the large del file: import from staffdata.del of del modified by chardel coldel, decpt. insert into newstaff.
然后我们使用DB 2import命令,用大型del文件中包含的数据填充这个新表:importfrom staffdata . del of del modifiedby chardel “ ” coldel, decpt . insert into newstaff。
应用推荐