Insert Query with auto-incrementing key

[Chris Weathers]

I have a users table with a primary key "id" that is set to auto-increment for new insertions. So a new user gets automatically assigned the number of users + 1 for their id.

How does my query from my jsp change in this situation? Do I just leave off the "id" field in the Insert query?

[Samuel Cox]

For oracle, mysql, sqlserver, db2?

For db2, I think we used identity_val_local or something like that. For sqlserver, you leave it off.

table {
id,
name
}
 
insert into table values ('Sam');