摘要:
不同数据库获取新增加的主键值 数据库获取新增主键的查询语句DB2IDENTITY_VAL_LOCAL()InformixSELECT dbinfo('sqlca.sqlerrd1') FROM <TABLE>SybaseSELECT @@IDENTITYSqlServerSELECT SCOPE_IDENTITY()或SELECT @@IDENTITYMySqlSELECT LAST_INSERT_ID()HsqlDBCALL IDENTITY()CloudscapeIDENTITY_VAL_LOCAL()DerbyIDENTITY_VAL_LOCAL()Postg 阅读全文