Reprinted on the Internet and configured the auto-increment column. A primary key without a database table is generally set as an auto-increment field. After a record is inserted, how to obtain the ID value of the record: Use the following function: Evaluate () DB2VALUESIDENTITY_VAL_LOCAL () DerbyVALUESIDENTITY_VAL_LOCAL () HSQLDBCALLIDENTITY (
Reprinted on the Internet and configured the auto-increment column. A primary key without a database table is generally set as an auto-increment field. After a record is inserted, how to obtain the ID value of the record: Use the following function: Cloudscape VALUES IDENTITY_VAL_LOCAL () DB2 VALUES IDENTITY_VAL_LOCAL () derby VALUES IDENTITY_VAL_LOCAL () hsqldb call identity (
Reprinted on the Internet and configured the auto-increment column. <无>
The primary key of a database table is generally set to an auto-increment field. After a record is inserted, how to obtain the ID value of the record: Use the following function: Cloudscape VALUES IDENTITY_VAL_LOCAL () DB2 VALUES IDENTITY_VAL_LOCAL () derby VALUES IDENTITY_VAL_LOCAL () hsqldb call identity () MySql SELECT LAST_INSERT_ID () SqlServer SELECT SCOPE_IDENTITY () sybase select @ identity oracle select CUSTOM_ SQL .NEXTVAL AS ID FROM DUAL