Kwa Kil On Swa

Thursday, November 16, 2006

derby auto generated keys identity autoincrement

ij> create table t1(c1 int generated always as identity, c2 int);
0 rows inserted/updated/deleted
ij> insert into t1(c2) values (8);
1 row inserted/updated/deleted
ij> values IDENTITY_VAL_LOCAL();

0 Comments:

Post a Comment

<< Home