So, although it should be unique, we can add any value we like, as shown in the INSERT statements that follow the CREATE statement.
所以,尽管它应该是惟一的,我们还是可以添加任何值,如CREATE语句后面的几个 INSERT语句中所示。
The application never knows what value is put into the primary key column after running the INSERT statement.
在运行insert语句之后,应用程序将永远都不知道放入了主键列中的是什么值。
DB2 will be responsible for generating a unique value for the column for each INSERT statement.
对于每条insert语句,DB 2将负责为其中的这一列生成一个惟一的值。
Select Insert data at the location of the applicable input field on the host screen, then enter the value you want, like 2.
在主机屏幕上适当的输入字段位置,选择Insertdata,然后按您的想法输入一个值,如2。
Then the file runs an INSERT statement with the id value plus one.
然后文件以id值加1运行一个insert语句。
The INSERT statement does not need to specify the value for the SERIALNUMBER column.
insert语句不需要指定serialnumber列的值。
But in DB2, you must provide a value for NOT NULL columns in an INSERT statement when a default hasn't been defined.
但在DB 2中,如果未定义该值,则必须在insert语句中为NOTnull列提供值。
Prior to the DB2 for I 6.1 release, SQL Update and Insert statements could use an indicator variable with a value of -1 to set a null capable column to the null value.
在DB 2fori 6.1发布之前,SQLUpdate和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值,这样就不会违反约束。
For example, a page that wants to use this template file needs to use the define tag, specifying for its name attribute the same name value referenced in the insert tag.
例如,一个准备使用该模板的页面需要使用define标记,将其name属性指定为insert标记中所引用的同一name值。
The addProduct() method in Listing 9 accepts a new product record as an array of key-value pairs and then uses the Zend_Db object's insert() method to write this record to the database table.
清单9中的 addProduct() 函数接收一个新产品记录作为键-值对数组,然后使用 Zend_Db对象的insert() 函数将记录写入到数据库表中。
An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
edition表上的after - insert触发器并非很有用,因为它只能截获其status值为start的记录行。
An after-insert trigger on the IWH.EDITION table is not useful, as only rows with a status value of start would be intercepted.
edition表上的after - insert触发器并非很有用,因为它只能截获其status值为start的记录行。
应用推荐