Adding a record in SQL with an autonumber

[cjard]

in oracle we do:


insert into table1
select max(id_number)+1, 'literal value for column 1', 'value for column 2', 'col 3' ...
from table1


the select statement returns 1 row that has:

the max id number +1, followed by all the literal text you put in, in columns

this row is then inserted. clever eh?