Re: automatically calculating ID field on INSERT

>> I have a table with a numeric ID field representing the primary key.
How can I use standard SQL to insert a record so that always a new value is created for the field ID ? <<

INSERT INTO MyTable (id, a, b, c, ...)
VALUES ((SELECT MAX(id) FROM MyTable) + 1, new_a, new_b, new_c, ...);

--CELKO--
Joe Celko, SQL and Database Consultant

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 18 2000 - 00:00:00 CEST