Re: auto-increment

[Nick Roper]

Or,

SELECT @max_id := MAX(id) FROM table;
INSERT INTO table (id, etc...) VALUES (@max_id + 1, etc...);

(Note: @var := expression
used to assign a value to a SQL variable)

Nick

--
Nick Roper